{"text_format":"3","workbook":"xlsx","n_sheets":19,"sheets":["Vsl Details","Checklist A","Checklist B","Checklist C","Master Comment","Departure Port Info","Dep Port Safety Setting","Berth to Pilot","Sea Passage Safety Setting","Sea Passage","Arrival Port Info","Arrival Port Safet Setting","Pilot to Berth","Implementation","Appendix Deviation","Amendment to Passage Plan","Post Voyage Review","Emer and Contingency Plan","Sample Emer & Contingency Plan"],"not_rendered":{"images":2,"macros":1,"external_links":1,"defined_names":51},"read":"whole","date_system":"1900"}

{"sheet":"Vsl Details","index":0,"n_rows":44,"n_cols":4,"rows_kept":44,"merged":[[0,0,2,0],[0,2,0,3],[1,2,1,3],[2,2,2,3]]}
["NAV-01",null,"Doc No :  NAV-01"]
[null,"PASSAGE PLAN","Revision: 01                                                              \nDate: 15 Oct 2024"]
[null,null,"Issued by: DPA\n Approved by: MD"]
[]
["Date",null,"2006-02-02"]
[]
["Vessel Name",null,"M/T Example"]
["Call Sign :",null,"GB07"]
["Voyage No",null,11]
["Ballast / Loaded :",null,"Loaded"]
[]
["From",null,"Singapore"]
["Berth"]
["GMT :",null,{"$f":"8","v":8}]
[]
["To",null,"Rotterdam"]
["Berth"]
["GMT :",null,1]
[]
["Via",null,"Suez"]
["GMT :",null,3]
[]
["Draft F",null,{"v":11,"d":"11.00 m"}]
["Draft Mid",null,{"$f":"+(C23+C25)/2","v":{"v":10.5,"d":"10.50 m"}}]
["Draft A",null,{"v":10,"d":"10.00 m"}]
["Trim",null,{"$f":"C25-C23","v":{"v":-1,"d":"-01.00 m"}}]
["Cb @",{"$f":"MAX(draft)","v":{"v":11,"d":"11.00 m (Block Coefficient)"}},0.8123]
["Air Draft (Mast Up)",null,{"$f":"C33-C37","v":{"v":58.34666733853618,"d":"58.35 m"}}]
["Air Draft (Mast Down)",null,{"$f":"C34-C38","v":{"v":-10,"d":"-10.00 m"}}]
[]
[]
["LBP (Between Perpendiculars)",null,{"v":315,"d":"315.00 m"}]
["Keel to Max. Hight (Mast Up)",null,{"v":68.48,"d":"68.48 m"}]
["Keel to Max. Hight (Mast Down)"]
["Dist. APP to Highest Point (Mast Up)",null,{"v":42,"d":"42.00 m"}]
["Dist. APP to Highest Point (Mast Down)"]
["Draft in the Highest Point (Mast Up)",null,{"$f":"(C25-(C35*(SIN(((TANH(C26/C32))/(PI()/180))*(PI()/180)))))","v":{"v":10.133332661463822,"d":"10.13 m"}}]
["Draft in the Highest Point (Mast Down)",null,{"$f":"(C25-(C36*(SIN(((TANH(C26/C32))/(PI()/180))*(PI()/180)))))","v":{"v":10,"d":"10.00 m"}}]
[]
[null,"Speed Variables"]
[1,"Full Ahead",{"v":13,"d":"13.0"},"knots"]
[2,"Half Ahead",9.8,"knots"]
[3,"Slow Ahead",7.7,"knots"]
[4,"Dead Slow Ahead",5.5,"knots"]

{"sheet":"Checklist A","index":1,"n_rows":56,"n_cols":25,"rows_kept":56,"merged":[[0,0,2,1],[0,2,0,12],[0,13,0,15],[1,2,1,12],[1,13,1,15],[2,2,2,12],[2,13,2,15],[4,3,4,5],[4,6,4,8],[6,0,6,1],[6,14,6,15],[7,6,7,9],[8,6,8,9],[9,6,9,9],[11,7,11,10],[11,17,12,20],[12,1,12,2],[13,0,13,7],[13,10,13,15],[14,0,14,1],[14,2,14,7],[15,0,15,1],[15,2,15,7],[16,0,16,1],[16,2,16,7],[17,0,17,1],[17,2,17,7],[18,0,18,1],[18,2,18,7],[19,0,19,1],[19,2,19,7],[20,0,20,1],[20,2,20,7],[21,0,21,1],[21,2,21,7],[21,12,21,15],[22,0,22,1],[22,2,22,7],[23,0,23,1],[24,0,24,7],[26,0,26,7],[26,9,26,12],[26,14,26,15],[27,1,27,7],[27,14,27,15],[28,1,28,7],[28,14,28,15],[29,1,29,7],[29,14,29,15],[30,1,30,7],[30,14,30,15],[31,1,31,7],[31,14,31,15],[32,1,32,7],[32,14,32,15],[33,1,33,7],[33,14,33,15],[34,1,34,6],[36,2,36,5],[36,6,36,15],[37,2,37,5],[37,6,37,15],[38,2,38,5],[38,6,38,15],[39,2,39,5],[39,6,39,15],[43,0,43,15],[44,0,44,15],[45,0,45,15],[46,0,46,15],[47,0,47,15],[48,14,48,15],[50,1,50,15]]}
["NAV-01",{"$nulls":12},"Doc No :  NAV-01"]
[null,null,"PASSAGE PLAN",{"$nulls":10},"Revision: 01                                                              \nDate: 15 Oct 2024"]
[{"$nulls":13},"Issued by: DPA\n Approved by: MD"]
[]
["Date :",{"$f":"'Vsl Details'!C5","v":"2006-02-02"},null,"Vessel Name :",null,null,{"$f":"'Vsl Details'!C7","v":"M/T Example"},{"$nulls":7},"Voyage No :",{"$f":"'Vsl Details'!C9","v":11}]
[]
["Draft",{"$nulls":5},"Port",{"$nulls":3},"Berth",{"$nulls":3},"Time"]
["Fwd :",{"$f":"'Vsl Details'!C23","v":{"v":11,"d":"11.00 m"}},{"$nulls":3},"From :",{"$f":"IF('Vsl Details'!C12=\"\",\"\",'Vsl Details'!C12)","v":"Singapore"},{"$nulls":3},{"$f":"IF('Vsl Details'!C13=\"\",\"\",'Vsl Details'!C13)","v":""},{"$nulls":3},"GMT :",{"$f":"'Vsl Details'!C14","v":8}]
["Mid :",{"$f":"'Vsl Details'!C24","v":{"v":10.5,"d":"10.50 m"}},{"$nulls":3},"To :",{"$f":"IF('Vsl Details'!C16=\"\",\"\",'Vsl Details'!C16)","v":"Rotterdam"},{"$nulls":3},{"$f":"IF('Vsl Details'!C17=\"\",\"\",'Vsl Details'!C17)","v":""},{"$nulls":3},"GMT :",{"$f":"'Vsl Details'!C18","v":1}]
["Aft :",{"$f":"'Vsl Details'!C25","v":{"v":10,"d":"10.00 m"}},{"$nulls":3},"Via :",{"$f":"IF('Vsl Details'!C20=\"\",\"\",'Vsl Details'!C20)","v":"Suez"},{"$nulls":7},"GMT :",{"$f":"'Vsl Details'!C21","v":3}]
["Trim :",{"$f":"B10-B8","v":{"v":-1,"d":"-01.00 m"}}]
["Air :",{"$f":"'Vsl Details'!C28","v":{"v":58.34666733853618,"d":"58.35 m"}},null,null,"Total Distance : ",null,null,{"$f":"'Sea Passage'!J109","v":{"v":16016.103436472162,"d":"16016.10"}}]
[]
[{"$nulls":9},"Charts: ","BA"]
["Coast Pilot Books",null,"NP: 63, 64, 3, 2, 1, 71, 70, 59.",{"$nulls":6},1111,2222,null,3333,4444,5555,6666]
["Admiralty List of Radio Signals",null,"Vol.1(1), 1(2), 2, 3(1), 3(2), 4,5,6(3), 6(5)."]
["Admiralty List of Lights",null,"Vol D, J, H."]
["Admiralty Tide Tables",null,"Vol 3, 2."]
["Tidal Stream Atlas",null,"N/A"]
["Mariner's Handbook",null,"NP 100"]
["Routeing Charts",null,"5126(7), 5126(8), 5125(8), 5124(8)."]
["Reporting *",null,"See enclosed forms",{"$nulls":6},"Reference Charts : ",null,null,"BA"]
[]
[]
["* Procedures on chart & bridge note book",{"$nulls":12}," "," "]
[]
["NAVIGATIONAL AIDS",{"$nulls":8},"STEAMING TIME",{"$nulls":4},"NAVTEX"]
["A","RADAR, ARPA, ECDIS.",{"$nulls":7},"Knots","Days",null,"Hours",null,"(B) Bahrain"]
["B","GLOBAL POSITIONING SYSTEM (GPS)",{"$nulls":7},{"$f":"J30-0.5","v":11.5},{"$f":"Y29","v":58},null,{"$f":"X29","v":{"v":0.7046466497531583,"d":"00.7"}},null,"(F) Bandar Abbas",{"$nulls":7},{"$f":"$H$12/J29","v":1392.7046466497532},{"$f":"MOD(W29,24)","v":{"v":0.7046466497531583,"d":"1"}},{"$f":"(W29-X29)/24","v":58}]
["C","NAVTEX, SAT-C.",{"$nulls":7},{"$f":"J31-0.5","v":{"v":12,"d":"12.0"}},55,null,{"v":14.675286372680148,"d":"14.7"},null,"(M) Masqat",{"$nulls":7},1334.6752863726801,{"v":14.675286372680148,"d":"15"},55]
["D","VISUAL BEARINGS.",{"$nulls":7},{"$f":"J32-0.5","v":12.5},53,null,{"v":9.288274917772924,"d":"09.3"},null,"(O) Durban",{"$nulls":7},1281.288274917773,{"v":9.288274917772924,"d":"9"},53]
["E","FACSIMILE (WEATHER FORECAST)",{"$nulls":7},{"$f":"'Vsl Details'!C41","v":{"v":13,"d":"13.0"}},51,null,{"v":8.007956651704717,"d":"08.0"},null,"(I) Porth Elizabeth",{"$nulls":7},1232.0079566517047,{"v":8.007956651704717,"d":"8"},51]
["F","ECHO SOUNDER.",{"$nulls":7},{"$f":"J32+0.5","v":13.5},49,null,{"v":10.378032331271243,"d":"10.4"},null,"(C) Cape Town",{"$nulls":7},1186.3780323312712,{"v":10.378032331271243,"d":"10"},49]
["G","CELESTIAL NAVIGATION",{"$nulls":7},{"$f":"J33+0.5","v":{"v":14,"d":"14.0"}},47,null,{"v":16.007388319440224,"d":"16.0"},null,"(U)(V) Fundy",{"$nulls":7},1144.0073883194402,{"v":16.007388319440224,"d":"16"},47]
["H","TOTAL TIDE USED FOR UKC CALCULATIONS? (Y/N)",{"$nulls":5},"YES"]
[]
[null,"NAVAREA","WARNING",{"$nulls":3},"CHART AFFECTED"]
[{"$nulls":6}," "]
[]
[]
[]
["MASTER'S DECLARATION"]
["This is to declare that "]
["A. Company's Minimum Requirement regarding the Under Keel Clearance  and air draft can be complied with. Company MUST be advised immediately in case company’s minimum requirements regarding UKC or air draft can not be complied with OR in case UKC or air draft can not be determined due to lack of information from Charterers Prior arrival, Masters must request local agents to provide information relating to prevailing weather conditions which may have an impact on safe navigation. (E.G Strong winds for an extended period of time which could effect depth of water in port, Currents or any other conditions which could have a negative effect)."]
["B. Company's Minimum Requirement regarding the Rest Hours can be complied with (The Marine Manager MUST be advised immediately in case Company’s / STCW  minimum requirements regarding Rest Hours cannot be complied with)"]
["C. MARPOL special areas marked/confirmed on the charts"]
["D. Passage Plan complies with security guidelines when transiting the HRA as designated. CSO will be advised if not able to comply with or require deviation to the requirement as listed in company procedures and alternate planning criteria/measures to mitigate the risk with security risk assessment to be taken in consultaion with the CSO."]
["E. For ECDIS compliant vessels route verification/route check of passage plan has been done to confirm the planned passage safety."]
[{"$nulls":14},"Master"]
[null,"Master's Comment"]
[null,"Passage Planning briefing done by Bridge Team on Date: "]
[null,"Prepared by:",null,"Read & Understood:",{"$nulls":4},"Read & Understood:",null,null,"Read & Understood:",null,"Verified:"]
[]
[null,"Signature:",null,"Signature:",{"$nulls":4},"Signature:",null,null,"Signature:",null,"Signature:"]
[null,"Nav. Off:",null,"3rd Officer :",{"$nulls":4},"Ch. Offr. :",null,null,"Ch. Eng. :",null,"Master :"]
[null,"Date: ",null,"Date:",{"$nulls":4},"Date: ",null,null,"Date: ",null,"Date:"]

{"sheet":"Checklist B","index":2,"n_rows":60,"n_cols":5,"rows_kept":60,"merged":[[0,0,2,0],[0,1,0,3],[1,1,1,3],[2,1,2,3],[5,0,5,4],[6,0,6,4],[11,0,11,4],[18,0,18,4],[19,0,19,3],[22,0,22,4],[23,1,23,4],[24,1,24,4],[25,1,25,4],[26,1,26,4],[27,1,27,4],[28,0,28,4],[32,1,32,4],[33,0,33,4],[37,1,37,2],[39,1,39,2],[41,1,41,2],[43,1,43,2],[44,1,44,2],[45,0,45,4],[46,1,46,4],[47,1,47,4],[48,1,48,4],[49,1,49,4],[51,1,51,4],[52,1,52,4],[53,1,53,4],[54,1,54,4],[55,1,55,4],[56,1,56,4],[58,0,58,4],[59,0,59,4]]}
["NAV-01",{"$nulls":3},"Doc No :  NAV-01"]
[null,"PASSAGE PLAN",null,null,"Revision: 01                                                              \nDate: 15 Oct 2024"]
[{"$nulls":4},"Issued by: DPA\nApproved by: MD"]
[]
["Passage Plan Appraisal & Checklist"]
["Appraisal & planning of passage to be done using information from relevant sources. Suggested sources are listed below. Click mouse on item to place Ö in boxes to left of items used in appraisal and planning."]
["Have the navigation charts been selected from chart catalogue, including"]
[null,"Large scale charts for coastal waters",null,null,"Planning Charts"]
[null,"Small scale charts for ocean passages",null,null,"Climatic and Pilot Charts"]
[null,"Planning Charts",null,null,"Load line Zone Charts"]
[null,"Routeing Charts"]
["Have the publication been selected, including"]
[null,"Ocean Passages of the World",null,null,"Bridge Procedures guide"]
[null,"Sailing Directions",null,null,"Guide to Port Entry"]
[null,"Current & Tidal Stream Atlases",null,null,"Port information from any source"]
[null,"Tidal Tables",null,null,"List of Lights"]
[null,"Distance Tables",null,null,"Radio Signals"]
[null,"Ship's Manouvering Data"]
["Have all navigation charts and publications have been corrected upto date, including"]
["All Charts & Publications are corrected to NTM to WK "]
[null,"Ordering of new charts / publications",null,null,"Local area warnings"]
[null,"Notices to Mariners",null,null,"NAVAREA navigational warnings"]
["Have the following been considered ?"]
[null,"Ship's Departure & Arrival drafts"]
[null,"Tidal Windows available"]
[null,"Tidal Currents"]
[null,"Ship's cargo and any special cargo stowage / carriage restrictions"]
[null,"If there are any special ship operational requirements for the passage"]
["Have the following been checked ?"]
[null,"Climatogical Data",null,null,"Navigational Aids available"]
[null,"Weather Forecast",null,null,"Navigational Hazards & Warnings"]
[null,"Weather Routeing",null,null,"Traffic Separation & Routeing Schemes"]
[null,"Navigation Charts & Publications for Vessel Traffic Scheme & Port Reporting Systems"]
["Have the following been marked on the charts ?"]
[null,"Parallel Index Lines",null,null,"Wheel over Position"]
[null,"Chart Changes",null,null,"Clearing Lines & bearings"]
[null,"Methods & frequency of position fixing",null,null,"Transits, heading marks & leading lines"]
[null,"No-Go Areas, Prominent navigation and \nradar marks, UKC, Safe distance off, Air Darft.",null,null,"Significant tides & current"]
[null,"Landfall targets and Lights",null,null,"Safe speed & necessary speed alterations"]
[null,"Position where echosounder would be activated",null,null,"Status of Engine Room "]
[null,"Anchor clearance",null,null,"Status of Bridge Watch Level"]
[null,"Abort Position ( Port / Channel / Berth Approach )",null,null,"Crossing and High traffic density areas"]
[null,"T & P Corrections",null,null,"Enviromental Sensitive Area"]
[null,"Vessel Contigency Plans & contigency Anchoring area ",null,null,"VTS & Reporting points"]
[null,"Emission Control Areas  Entry and Exit points",null,null,"Fuel Oil Change over for ECA region"]
["Have the following preparations been made for port arrival ?"]
[null,"Navigational Charts & publications studies for pilotage requirements"]
[null,"NAV-05 & NAV-02 as part of Bridge Pilot Information Exchange"]
[null,"NAV 04 Pilot Card"]
[null,"Port guides studied for port information including arrival / berthing restrictions"]
["Other Checks"]
[null,"The Chief Engineer in consulatation with the master determine in advance the needs of the intended voyage taking into requirements of fuel, water , lubricantrs , chemicals , expendable and other spare parts , tools , supplies and any other requirement"]
[null,"Flags are available for countries in the intended  voyage - 3rd Officer"]
[null,"Vessel complying with IMO Intact stability requirements & Bridge Visibility Criteria - Chief Officer"]
[null,"Ballast exchange requirments known and planned complyting with requirements - Chief Officer"]
[null,"Compliance to Emission Control Area low sulphur fuel oil regulations,change over procedure,required quantity of LSFO/LSMGO planned with C/E."]
[null,"MARPOL Convention‘s annexes/special areas marked-activated   "]
[]
["___________              __________           ___________              _____________                ___________"]
["2nd Officer                3rd Officer            Chief Officer              Chief Engineer                 Master"]

{"sheet":"Checklist C","index":3,"n_rows":70,"n_cols":13,"rows_kept":70,"merged":[[2,0,2,12],[3,8,3,10],[4,0,4,9],[5,1,5,9],[6,1,6,9],[7,1,7,9],[8,1,8,9],[9,1,9,9],[10,1,10,9],[11,1,11,9],[12,1,12,9],[13,1,13,9],[14,1,14,9],[15,1,15,9],[16,1,16,9],[17,1,17,9],[18,1,18,9],[19,1,19,9],[20,1,20,9],[21,1,21,9],[22,1,22,9],[23,1,23,9],[24,1,24,9],[25,1,25,9],[26,1,26,9],[27,1,27,9],[28,1,28,9],[29,1,29,9],[30,0,30,9],[31,0,37,0],[31,1,31,9],[32,1,32,9],[33,1,33,9],[34,1,34,9],[35,1,35,9],[36,1,36,9],[37,1,37,9],[42,0,42,9],[43,0,67,0],[43,1,43,9],[44,1,44,9],[45,1,45,9],[46,1,46,9],[47,1,47,9],[48,1,48,9],[49,1,49,9],[50,1,50,9],[51,1,51,9],[52,1,52,9],[53,1,53,9],[54,1,54,9],[55,1,55,9],[56,1,56,9],[57,1,57,12],[58,1,58,9],[59,1,59,9],[60,1,60,9],[61,1,61,9],[62,1,62,9],[63,1,63,9],[64,1,64,9],[65,1,65,9],[66,1,66,9],[67,1,67,9],[68,0,68,12],[69,0,69,2],[69,3,69,5],[69,6,69,8],[69,9,69,12],[70,0,71,2],[70,3,71,5],[70,6,71,8],[70,9,71,12],[72,1,72,9],[73,10,73,12]]}
[]
[]
["ECDIS - Voyage Plan - Checklist  - (To be used for vessels fitted with ECDIS) "]
["Voyage From: ",{"$nulls":3},"To:"]
[{"$nulls":10},"Yes","No ","N/A"]
[null,"General"]
[1,"S57 ENC Charts with Permit for the entire voyage available in the ECDIS Catalogue & installed? "]
[2,"S57 ENC Charts updated with latest Base and Update CDs? "]
[3,"Latest AIO CD installed on the system and confirmed that all T & P and NAV warnings are showing on the ECDIS. "]
[4,"ENC/ ECDIS Data presenattion & performance cheks completed as per MSC.1/Circ.1391"]
[5,"Is the route prepared using safe settings for Draught, Safety Contour, and Depth Contours in compliance with company Under Keel Clearance policy and with due regards to Squat Effect (Including Trim & Heel?) "]
[6,"Estimated speed for each leg entered into voyage plan? "]
[7,"Channel width set to a minimum of 2NM at open sea (if possible) "]
[8,"Check of WGS-84 datum in GPS, ECDIS and used charts? (ENC vector charts according to S57 standard is produced in the WGS-84 datum) "]
[9,"Calculated ETA in route planning tool using present departure date? "]
[10,"CPA/ TCPA & Safety Frame ( Look Ahead) parameters correctly set up"]
[null,"USER MAP and NOTES created and/or updated for the voyage? Containing as a minimum the followed items: "]
[11,"Pilot reporting points? "]
[12,"Mandatory reporting points? "]
[13,"Point of no return for narrow passages? "]
[14,"Contingency anchorages? "]
[15,"No Go Areas (Using Channel Limits and User Danger Areas in User Chart)? "]
[16,"Conspicuous targets for positions fixing and cross checking reference? "]
[17,"Parallel indexing? "]
[18,"Areas with high speed vessels? "]
[19,"Relevant Navtex warnings and T&P's entered using Manual updates and Notes? "]
[20,"Echo sounder programmed in DBS mode? Vessel draught + UKC?"]
[21,"Voyage plan, notes and user MAP switched to monitoring mode? "]
[22,"Voyage Log, Distance Log reset? "]
[23,"Line of Position ( LOP) and Frequency entered? "]
["Chart Alert setting used for planning the route:",{"$nulls":9},"Alarm","Ind.","Off"]
[null,"Traffic Seperation Zone "]
[null,"Traffic Crossing "]
[null,"Traffic Roundabout "]
[null,"Traffic Precautionary"]
[null,"Two Way Traffic "]
[null,"Deep Water Route"]
[null,"Recommended Traffic Lane"]
[]
[]
[]
[]
["Chart Alert setting used for planning the route:",{"$nulls":9},"Alarm","Ind.","Off"]
[null,"Inshore Traffic Zone "]
[null,"Fairway"]
[null,"Restricted Area"]
[null,"Caution Area"]
[null,"Offshore Production Area"]
[null,"Military Practice Area "]
[null,"Seaplane Landing Area "]
[null,"Submarine Transit Area"]
[null,"Ice Area "]
[null,"Channel "]
[null,"Fishing Ground"]
[null,"Fishing Prohibited"]
[null,"Pipeline Area "]
[null,"Cable Area "]
[null,"Achorage Area"]
[null,"Anchorage prohibited "]
[null,"Spoil Ground "]
[null,"Dumping Ground "]
[null,"Dredge Area"]
[null,"Cargo Transhipment Area "]
[null,"Incineration Area "]
[null,"Specially Protected Area "]
[null,"Sensitive Sea Area "]
[null,"Archipelagic Sealane "]
[null,"Marine Farm/Aquaculture"]
["The methods to be used for cross-checking are by all other means available - such as visual bearings, radar position by brg/dist, parallel index etc. It is important for the navigator to practice all the traditional navigational skills and not to be overly confident in the informationfrom the ECDIS. During the voyage GPS signal quality should be monitored continuously. "]
["Navigating Off.",null,null,"3RD Off.",null,null,"CH/Off.",null,null,"Master"]

{"sheet":"Master Comment","index":4,"n_rows":50,"n_cols":1,"rows_kept":50,"merged":[[2,0,2,8],[3,0,19,8],[20,0,21,8],[22,0,22,8],[23,0,46,8]]}
[]
["Additional Remarks "]
["( Please enter remarks regarding anticipated Ocean currents, Visibility & Other Meterological Conditions; Areas of high traffic density ; Ship operations which may require additional searoom e.g tank cleaning or pilot embarkation ; the availability and reliability of navigation aids, marks lights and radar consipicous objects etc )"]
{"$rows_empty":17}
["Master's Comments (navigation related instructions in the charterers voyage orders / past experience etc.)"]
[]
["Ensure that the post voyage review is completed under the dedicated tab after the voyage is completed. "]
{"$rows_empty":25}
["Master :"]
["Signature :"]

{"sheet":"Departure Port Info","index":5,"n_rows":31,"n_cols":4,"rows_kept":31,"merged":[[1,3,1,4],[2,0,2,4],[9,0,9,4],[17,0,17,4],[27,1,27,4],[29,0,29,4],[31,0,31,4]]}
[]
[]
["PORT OF DEPARTURE INFORMATION"]
["Passage Plan Name on ECDIS"]
["User Chart name on ECDIS"]
["Name of Departure Berth"]
["VHF Channel(s) - Port Control"]
["VHF Channel(s) - VTS"]
["VHF Channel(s) - Pilots"]
["Tidal Information"]
["Standard Port"]
["Date"]
[null,"TIME ","HEIGHT"]
["High Water",null,null,"Mtrs"]
["Low Water",null,null,{"$f":"$D$14","v":"Mtrs"}]
["High Water",null,null,{"$f":"$D$14","v":"Mtrs"}]
["Low Water",null,null,{"$f":"$D$14","v":"Mtrs"}]
["Estimated Draft on Departure"]
["Forward",null,"Mtrs"]
["Aft",null,"Mtrs"]
["Mean",null,"Mtrs"]
["Vessel’s Maximum Air-draft",null,"Mtrs"]
["Distance - Berth to Pilot Station",null,"NM"]
["Estimated Time to Pilot Station",null,"Hours"]
["Is There a Change of Pilots?"]
["If Yes, Where"]
["Number of Tugs"]
["Location Tugs will Leave Vessel"]
["Remarks: (General route, channel to use, special precaution, etc)"]
[]
["Prevailing Current / Weather Information "]

{"sheet":"Dep Port Safety Setting","index":6,"n_rows":31,"n_cols":8,"rows_kept":31,"merged":[[0,0,0,4],[1,3,1,4],[16,0,16,4],[17,0,17,4],[18,0,18,4],[19,0,19,4],[20,0,20,4],[21,0,21,4],[22,0,22,4],[23,0,23,4],[24,0,24,4],[26,1,26,3],[27,1,27,3],[28,1,29,3],[30,1,30,3]]}
["Safety Setting Departure Port"]
["Beam:",32,"Cb:",0.7786]
["AREA","Ocean Passage (Open)","Fairways outside ports (Coastal / Shallow waters)","Fairways inside ports (Within Port Limits / Restricted Waters)","Remarks"]
["MAX. SPEED",{"v":12.5,"d":"12.50"},{"v":12.5,"d":"12.50"},{"v":5,"d":"5.00"}]
["DEEPEST DRAFT",9.85,9.85,9.85,"Static Draft"]
["TOTAL CALCULATED SQUAT",{"v":1.5,"d":"1.50"},{"v":1.5,"d":"1.50"},{"v":0.4,"d":"0.40"}]
["SAFETY MARGIN",{"v":2,"d":"2.00"},{"v":0.5,"d":"0.50"},{"v":0.4,"d":"0.40"},"Ensure it is equal to A3 in NAV 02 (Catzoc Consideration Tab)."]
["MINIMUM UKC REQUIRED",{"$f":"(B5+B6+B7)/2","v":{"v":6.675,"d":"6.68"}},{"$f":"(C5+C6+C7)*0.15","v":{"v":1.7774999999999999,"d":"1.78"}},{"$f":"IF(F8>G8,F8,G8)","v":{"v":0.6,"d":"0.60"}},null,{"$f":"B2*0.015","v":0.48},0.6]
["TIDE",{"v":2,"d":"2.00"},{"v":1.5,"d":"1.50"},{"v":1.3,"d":"1.30"}]
["SAFETY DEPTH",{"$f":"IF((B5+B6+B8+B7-B9)<B5,ROUNDUP(B5,0),ROUNDUP((B5+B6+B8+B7-B9),0))","v":{"v":19,"d":"19.00"}},{"$f":"IF((C5+C6+C8+C7-C9)<C5,ROUNDUP(C5,0),ROUNDUP((C5+C6+C8+C7-C9),0))","v":{"v":13,"d":"13.00"}},{"$f":"IF((D5+D6+D8+D7-D9)<D5,ROUNDUP(D5,0),ROUNDUP((D5+D6+D8+D7-D9),0))","v":{"v":10,"d":"10.00"}}]
["SAFETY CONTOUR",{"$f":"B10","v":{"v":19,"d":"19.00"}},{"$f":"C10","v":{"v":13,"d":"13.00"}},{"$f":"D10","v":{"v":10,"d":"10.00"}}]
["SHALLOW CONTOUR",{"$f":"IF(ROUNDUP((B5+1),0)>=B11,B5,ROUNDUP((B5+1),0))","v":{"v":11,"d":"11.00"}},{"$f":"IF(ROUNDUP((C5+1),0)>=C11,C5,ROUNDUP((C5+1),0))","v":{"v":11,"d":"11.00"}},9.85]
["DEEP CONTOUR",{"$f":"ROUNDUP((F13*2),0)","v":{"v":23,"d":"23.00"}},{"$f":"ROUNDUP((G13*2),0)","v":{"v":23,"d":"23.00"}},{"$f":"ROUNDUP((H13*2),0)","v":{"v":21,"d":"21.00"}},null,{"$f":"B5+B6","v":11.35},{"$f":"C5+C6","v":11.35},{"$f":"D5+D6","v":10.25}]
["Look Ahead Settings",{"$nulls":3},"FOM 3.29 Section 5.6"]
["Cross Track Distance",{"$nulls":3},"FOM 3.29 Section 5.8"]
[]
["SHALLOW CONTOUR = Next contour shallower than safety contour/must not be less than vessel’s draft"]
["SAFETY DEPTH = Vessel Draft + Dynamic Squat + UKC + Safety Margin - Height of Tide"]
["SAFETY CONTOUR = Safety contour should be set at a value equal to the safety depth"]
["DEPTH CONTOUR = Twice the Dynamic Draft (Max. Static draft + Squat)"]
["ECHO SOUNDER = Ensure alarm, if fitted, is used for safe navigation. "]
["NOTE (when marking NO GO AREA on ECDIS):"]
[]
["Shallow Contour should not be confused by the wording 'contour'. The safe/unsafe contour for Navigation is the safety contour. A shallow contour is only for additional indication of the underwater topography of the already 'un-safe' water; it is not calculation between draft and tide values. Reminding once again that the safety of the navigation is only to be dependent upon the 'Safety Contour' & 'Safety Depth' mentioned above."]
["All ECDIS parameters set prior to the beginning of the voyage must not be removed/changed/de-activated without permission from the Master. Any safety parameters to be re-set to original settings after planning/trial/simulation mode"]
[]
["Prepared by :"]
[null,"Second Officer"]
[]
["Calculation confirmed by :"]
[null,"Master"]

{"sheet":"Berth to Pilot","index":7,"n_rows":40,"n_cols":87,"rows_kept":40,"merged":[[2,1,2,2],[3,7,3,9],[4,1,4,2],[4,6,4,9],[4,12,4,14],[5,7,5,12],[6,0,8,0],[6,1,8,1],[6,2,7,4],[6,5,7,7],[6,8,8,8],[6,9,8,9],[6,10,8,10],[6,11,8,11],[6,12,7,15],[6,16,8,16],[6,17,8,17],[6,18,8,18],[6,19,8,19],[6,20,7,20],[6,21,8,21],[6,22,8,22],[6,23,7,24],[39,5,39,7]]}
[]
[]
[null,"All dates & times are GMT",{"$nulls":9},{"$f":"+'Vsl Details'!C7","v":"M/T Example"}]
[null,"PILOTS",null,"SPD"," ","Voy :",{"$f":"+'Vsl Details'!C9","v":11},{"$f":"+'Vsl Details'!C10","v":"Loaded"},null,null,"Time"]
[null,"2005-07-22T12:00:00",null,14.3," ","From :",{"$f":"'Checklist A'!$G$8","v":"Singapore"},{"$nulls":3},{"$f":"+'Vsl Details'!C14","v":{"v":8,"d":" 8"}},"To :",{"$f":"'Checklist A'!$G$9","v":"Rotterdam"},null,null,{"$f":"+'Vsl Details'!C18","v":{"v":1,"d":" 1"}},{"$nulls":6},"Berth to Pilot"]
[{"$nulls":3}," "," "," "]
["WP No.","GEOGRAPHICAL AREA WAYPOINT","LATITUDE",null,null,"LONGITUDE",null,null,"CO","DIST. TO NEXT WP","DTG","RL/GC","Verification Freq / Method",{"$nulls":3},"Max Spd (kts)","T&P Notices","Safety Setting","UKC","MARPOL Special area / ECA Zone","Security Level","Remarks: NAV Aids, Restrictions, Weather, Cautions, Traffic Density, UKC, Tides etc, T&P notice number effecting each leg, extra lookout if passing through HRA, Area where vessel should be hardened.","Watch Level"]
[{"$nulls":26},"latrad","longrad","dlon_W","dlon_E","dphi","q1","q","dlon_min","tc_rad","tc","dist_rad","dist",{"$nulls":30},"Yes"]
[null,null,"DEG","MIN","N/S","DEG","MIN","E/W",{"$nulls":4},"Freq","Main","Alt 1","Alt 2",{"$nulls":4},"Yes / No",null,null,"Bridge","E/R",{"$nulls":43},"No",{"$nulls":16},"Course","Distance"]
["BP 1","PILOT STATION",{"v":27,"d":"27°"},{"v":0,"d":"00.00`"},"S",{"v":160,"d":"160°"},{"v":9,"d":"09.00`"},"E",{"$f":"IF(C11=\"\",\"\",IF(AD10<AC10,360-AJ10,AJ10))","v":{"v":27.7622246258402,"d":"028°"}},{"$f":"IF(C11=\"\",0,+AL10)","v":{"v":3674.4751808764377,"d":"3674.5"}},{"$f":"+J40","v":{"v":16016.103436472162,"d":"16016.1"}},null,"< 1 h","Vis","Rdr","Gps",null,"Yes","Ocean Passage (Open)",null,"Yes","Level 1",{"$nulls":4},{"$f":"IF(E10=\"N\",RADIANS(C10+(D10/60)),-RADIANS(C10+(D10/60)))","v":-0.47123889803846897},{"$f":"IF(H10=\"E\",+RADIANS(F10+(G10/60)),-RADIANS(F10+(G10/60)))","v":2.795144797068919},{"$f":"MOD(AB11-AB10,2*PI())","v":0.517548300858051},{"$f":"MOD(AB10-AB11,2*PI())","v":5.765637006321535},{"$f":"LN(TAN(AA11/2+PI()/4)/TAN(AA10/2+PI()/4))","v":0.9831883810571177},{"$f":"COS(AA10)","v":0.8910065241883679},{"$f":"IF(AA11=AA10,AF10,(AA11-AA10)/AE10)","v":0.9619957158765963},{"$f":"MIN(AC10,AD10)","v":0.517548300858051},{"$f":"MOD(ATAN2(AE10,AH10),2*PI())","v":0.4845422273991623},{"$f":"DEGREES(AI10)","v":{"v":27.7622246258402,"d":"27.8"}},{"$f":"SQRT(AG10^2*AH10^2+(AA11-AA10)^2)","v":1.0688615031518003},{"$f":"DEGREES(AK10)*60","v":{"v":3674.4751808764377,"d":"3674.5"}},{"$nulls":30},"Level 1",{"$nulls":16},{"$f":"I10","v":{"v":27.7622246258402,"d":"27.76222"}},{"$f":"J10","v":{"v":3674.4751808764377,"d":"3674.4752"}}]
["BP 2","GHAR BUOY",{"v":27,"d":"27°"},{"v":11.5,"d":"11.50`"},"N",{"v":170,"d":"170°"},{"v":11.8,"d":"11.80`"},"W",{"v":269.9992267849206,"d":"270°"},{"v":7410.070113943125,"d":"7410.1"},{"$f":"+K10-J10","v":{"v":12341.628255595724,"d":"12341.6"}},null,"< 1 h","Vis","Rdr","Gps",null,null,"Fairways outside ports (Coastal / Shallow waters)",{"$nulls":7},{"$f":"IF(E11=\"N\",RADIANS(C11+(D11/60)),-RADIANS(C11+(D11/60)))","v":0.47458411243812476},{"$f":"IF(H11=\"E\",+RADIANS(F11+(G11/60)),-RADIANS(F11+(G11/60)))","v":-2.970492209252616},{"$f":"MOD(AB12-AB11,2*PI())","v":3.8598829072480596},{"$f":"MOD(AB11-AB12,2*PI())","v":2.4233023999315266},{"$f":"LN(TAN(AA12/2+PI()/4)/TAN(AA11/2+PI()/4))","v":-3.2702826867868676E-5},{"$f":"COS(AA11)","v":0.8894828460823052},{"$f":"IF(AA12=AA11,AF11,(AA12-AA11)/AE11)","v":0.889489492271762},{"$f":"MIN(AC11,AD11)","v":2.4233023999315266},{"$f":"MOD(ATAN2(AE11,AH11),2*PI())","v":1.570809821943858},{"$f":"DEGREES(AI11)","v":{"v":90.00077321507939,"d":"90.0"}},{"$f":"SQRT(AG11^2*AH11^2+(AA12-AA11)^2)","v":2.155502021532315},{"$f":"DEGREES(AK11)*60","v":{"v":7410.070113943125,"d":"7410.1"}},{"$nulls":30},"Level 2",{"$nulls":16},{"v":269.9992267849206,"d":"269.99923"},{"v":7410.070113943125,"d":"7410.0701"}]
["BP 3","RAS TANNURAH RACON (K)",{"v":27,"d":"27°"},{"v":11.4,"d":"11.40`"},"N",{"v":50,"d":"050°"},{"v":57.5,"d":"57.50`"},"E",{"v":98.89184782811951,"d":"099°"},{"v":60.81394329207227,"d":"60.8"},{"$f":"+K11-J11","v":{"v":4931.558141652599,"d":"4931.6"}},null,"< 1 h","Vis","Rdr","Gps",null,null,"Fairways inside ports (Within Port Limits / Restricted Waters)",{"$nulls":7},{"$f":"IF(E12=\"N\",RADIANS(C12+(D12/60)),-RADIANS(C12+(D12/60)))","v":0.4745550236172582},{"$f":"IF(H12=\"E\",+RADIANS(F12+(G12/60)),-RADIANS(F12+(G12/60)))","v":0.8893906979954438},0.019634954084936207,6.26355035309465,-3.0718896058628425E-3,0.8894961383826187,0.89011960463655,0.019634954084936207,1.7259883479818887,{"v":98.89184782811951,"d":"98.9"},0.017690059026129676,{"v":60.81394329207227,"d":"60.8"},{"$nulls":30},"Level 3",{"$nulls":16},{"v":98.89184782811951,"d":"98.89185"},{"v":60.81394329207227,"d":"60.8139"}]
["BP 4","FIELD",{"v":27,"d":"27°"},{"v":2,"d":"02.00`"},"N",{"v":52,"d":"052°"},{"v":5,"d":"05.00`"},"E",{"v":131.88581763263926,"d":"132°"},{"v":29.955891612915163,"d":"30.0"},{"v":4870.744198360527,"d":"4870.7"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.47182067445580045,0.90902565208038,0.007272205216643068,6.275913101962943,-0.006521728036198491,0.8907422524501034,0.8920586907370712,0.007272205216643068,2.3018417543743483,{"v":131.88581763263926,"d":"131.9"},0.008713815650265406,{"v":29.955891612915163,"d":"30.0"},{"$nulls":30},"Ocean Passage (Open)","Fairways outside ports (Coastal / Shallow waters)","Fairways inside ports (Within Port Limits / Restricted Waters)",{"$nulls":14},{"v":131.88581763263926,"d":"131.88582"},{"v":29.955891612915163,"d":"29.9559"}]
["BP 5","CABLE BANK",{"v":26,"d":"26°"},{"v":42,"d":"42.00`"},"N",{"v":52,"d":"052°"},{"v":30,"d":"30.00`"},"E",{"v":106.49874610577218,"d":"106°"},{"v":104.5795411838232,"d":"104.6"},{"v":4840.788306747611,"d":"4840.8"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.46600291028248597,0.9162978572970231,0.03257947937056083,6.250605827809025,-0.009649705905783667,0.8933713883278376,0.8952998030949143,0.03257947937056083,1.858753768791214,{"v":106.49874610577218,"d":"106.5"},0.030420955398045384,{"v":104.5795411838232,"d":"104.6"},{"$nulls":47},{"v":106.49874610577218,"d":"106.49875"},{"v":104.5795411838232,"d":"104.5795"}]
["BP 6","FORUR ISLAND",{"v":26,"d":"26°"},{"v":12.3,"d":"12.30`"},"N",{"v":54,"d":"054°"},{"v":22,"d":"22.00`"},"E",{"v":96.64091344577552,"d":"097°"},{"v":50.15285243581551,"d":"50.2"},{"v":4736.208765563788,"d":"4736.2"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.457363530485114,0.9488773366675839,0.016144295580947432,6.267041011598639,-1.8796422586359032E-3,0.8972198376038806,0.897591870213388,0.016144295580947432,1.6867021317636413,{"v":96.64091344577552,"d":"96.6"},0.014588873404530646,{"v":50.15285243581551,"d":"50.2"},{"$nulls":47},{"v":96.64091344577552,"d":"96.64091"},{"v":50.15285243581551,"d":"50.1529"}]
["BP 7","TONBE ISLAND",{"v":26,"d":"26°"},{"v":6.5,"d":"06.50`"},"N",{"v":55,"d":"055°"},{"v":17.5,"d":"17.50`"},"E",{"v":70.38069863120359,"d":"070°"},{"v":11.912955468934165,"d":"11.9"},{"v":4686.055913127972,"d":"4686.1"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.4556763788748529,0.9650216322485313,3.6361026083215897E-3,6.279549204571264,1.2961382792950143E-3,0.8979635797038885,0.8977073304985035,3.6361026083215897E-3,1.228374920968369,{"v":70.38069863120359,"d":"70.4"},0.003465338276272771,{"v":11.912955468934165,"d":"11.9"},{"$nulls":47},{"v":70.38069863120359,"d":"70.38070"},{"v":11.912955468934165,"d":"11.9130"}]
["BP 8","TSS OUT",{"v":26,"d":"26°"},{"v":10.5,"d":"10.50`"},"N",{"v":55,"d":"055°"},{"v":30,"d":"30.00`"},"E",{"v":66.65374013681041,"d":"067°"},{"v":51.73019652138883,"d":"51.7"},{"v":4674.142957659038,"d":"4674.1"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.45683993170951576,0.9686577348568529,0.015417075059283247,6.267768232120303,0.006654402881355833,0.8974509275255026,0.8961297330456026,0.015417075059283247,1.1633272241560373,{"v":66.65374013681041,"d":"66.7"},0.015047704200032538,{"v":51.73019652138883,"d":"51.7"},{"$nulls":47},{"v":66.65374013681041,"d":"66.65374"},{"v":51.73019652138883,"d":"51.7302"}]
["BP 9","TSS HORMUZ 1",{"v":26,"d":"26°"},{"v":31,"d":"31.00`"},"N",{"v":56,"d":"056°"},{"v":23,"d":"23.00`"},"E",{"v":65.17850251325903,"d":"065°"},{"v":5.717108158419505,"d":"5.7"},{"v":4622.412761137649,"d":"4622.4"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.46280313998716305,0.9840748099161362,1.6871516102611173E-3,6.2814981555693254,7.8034179774028913E-4,0.8948045300584291,0.8946486050335065,1.6871516102611173E-3,1.1375794703757691,{"v":65.17850251325903,"d":"65.2"},1.6630393509508323E-3,{"v":5.717108158419505,"d":"5.7"},{"$nulls":47},{"v":65.17850251325903,"d":"65.17850"},{"v":5.717108158419505,"d":"5.7171"}]
["BP 10","TSS HORMUZ 2",{"v":26,"d":"26°"},{"v":33.4,"d":"33.40`"},"N",{"v":56,"d":"056°"},{"v":28.8,"d":"28.80`"},"E",{"v":90,"d":"090°"},{"v":3.5779705018346784,"d":"3.6"},{"v":4616.69565297923,"d":"4616.7"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.46350127168796074,0.9857619615263973,1.163552834662962E-3,6.282021754344923,0,0.8944926254586114,0.8944926254586114,1.163552834662962E-3,1.5707963267948966,{"v":90,"d":"90.0"},1.0407894299374826E-3,{"v":3.5779705018346784,"d":"3.6"},{"$nulls":47},{"v":90,"d":"90.00000"},{"v":3.5779705018346784,"d":"3.5780"}]
["BP 11","TSS HORMUZ 3",{"v":26,"d":"26°"},{"v":33.4,"d":"33.40`"},"N",{"v":56,"d":"056°"},{"v":32.8,"d":"32.80`"},"E",{"v":149.3791183222242,"d":"149°"},{"v":62.05287305205036,"d":"62.1"},{"v":4613.117682477395,"d":"4613.1"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.46350127168796074,0.9869255143610602,0.010239264945033355,6.272946042234553,-0.01729925893452955,0.8944926254586114,0.8979246106169625,0.010239264945033355,2.607157448449,{"v":149.3791183222242,"d":"149.4"},0.01805044908467236,{"v":62.05287305205036,"d":"62.1"},{"$nulls":47},{"v":149.3791183222242,"d":"149.37912"},{"v":62.05287305205036,"d":"62.0529"}]
["BP 12","RAS AL KUH 1",{"v":25,"d":"25°"},{"v":40,"d":"40.00`"},"N",{"v":57,"d":"057°"},{"v":8,"d":"08.00`"},"E",{"v":140.00938056519738,"d":"140°"},{"v":13.052279960938492,"d":"13.1"},{"v":4551.064809425345,"d":"4551.1"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.4479678413452113,0.9971647793060936,2.7052603405912645E-3,6.280480046838995,-0.00322507590361609,0.9013291614454622,0.9019577131179077,2.7052603405912645E-3,2.4436246745404535,{"v":140.00938056519738,"d":"140.0"},3.7967543368408923E-3,{"v":13.052279960938492,"d":"13.1"},{"$nulls":47},{"v":140.00938056519738,"d":"140.00938"},{"v":13.052279960938492,"d":"13.0523"}]
["BP 13","RAS AL KUH 2",{"v":25,"d":"25°"},{"v":30,"d":"30.00`"},"N",{"v":57,"d":"057°"},{"v":17.3,"d":"17.30`"},"E",{"v":136.30273186512736,"d":"136°"},{"v":124.48131292684803,"d":"124.5"},{"v":4538.012529464406,"d":"4538.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.44505895925855404,0.9998700396466849,0.02754711336064375,6.2556381938189425,-0.02882915937034003,0.9025852843498606,0.9081062143924088,0.02754711336064375,2.378931450509464,{"v":136.30273186512736,"d":"136.3"},0.03621014612964796,{"v":124.48131292684803,"d":"124.5"},{"$nulls":47},{"v":136.30273186512736,"d":"136.30273"},{"v":124.48131292684803,"d":"124.4813"}]
["BP 14","24° NORTH",{"v":24,"d":"24°"},{"v":0,"d":"00.00`"},"N",{"v":58,"d":"058°"},{"v":52,"d":"52.00`"},"E",{"v":136.39000837687638,"d":"136°"},{"v":110.48936444860492,"d":"110.5"},{"v":4413.531216537558,"d":"4413.5"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.4188790204786391,1.0274171530073286,0.024143721319255018,6.259041585860331,-0.025344553488278247,0.9135454576426009,0.9181876770494501,0.024143721319255018,2.38045471299914,{"v":136.39000837687638,"d":"136.4"},0.03214005330106875,{"v":110.48936444860492,"d":"110.5"},{"$nulls":47},{"v":136.39000837687638,"d":"136.39001"},{"v":110.48936444860492,"d":"110.4894"}]
["BP 15","RAS AL HADD",{"v":22,"d":"22°"},{"v":40,"d":"40.00`"},"N",{"v":60,"d":"060°"},{"v":15,"d":"15.00`"},"E",{"v":180,"d":"180°"},{"v":40.00000000000012,"d":"40.0"},{"v":4303.041852088953,"d":"4303.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.3956079637853814,1.0515608743265836,0,0,-0.012579196741493666,0.9227624443554423,0.9249818240180641,0,3.141592653589793,{"v":180,"d":"180.0"},0.011635528346628898,{"v":40.00000000000012,"d":"40.0"},{"$nulls":47},{"$f":"I24","v":{"v":180,"d":"180.00000"}},{"$f":"J24","v":{"v":40.00000000000012,"d":"40.0000"}}]
["BP 16","RAS QUMAYLAH",{"v":22,"d":"22°"},{"v":0,"d":"00.00`"},"N",{"v":60,"d":"060°"},{"v":15,"d":"15.00`"},"E",{"v":204.09544375790784,"d":"204°"},{"v":618.9293944162871,"d":"618.9"},{"v":4263.041852088953,"d":"4263.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.3839724354387525,1.0515608743265836,6.20609993188317,0.07708537529641624,-0.17236328619713176,0.9271838545667874,0.9535199839956845,0.07708537529641624,2.721047825285186,{"v":155.90455624209216,"d":"155.9"},0.1800392628323136,{"v":618.9293944162871,"d":"618.9"},{"$nulls":47},{"v":204.09544375790784,"d":"204.09544"},{"v":618.9293944162871,"d":"618.9294"}]
["BP 17","SUQUTRA",{"v":12,"d":"12°"},{"v":35,"d":"35.00`"},"N",{"v":55,"d":"055°"},{"v":50,"d":"50.00`"},"E",{"v":208.69878397038536,"d":"209°"},{"v":1647.368785180876,"d":"1647.4"},{"v":3644.112457672666,"d":"3644.1"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.2196205975426198,0.9744754990301674,6.051347404873006,0.2318379023065802,-0.4234819293166806,0.9759801759455132,0.9925652841910086,0.2318379023065802,2.6407043819879976,{"v":151.30121602961464,"d":"151.3"},0.4792001549330909,{"v":1647.368785180876,"d":"1647.4"},{"$nulls":47},{"v":208.69878397038536,"d":"208.69878"},{"v":1647.368785180876,"d":"1647.3688"}]
["BP 18","COMORES",{"v":11,"d":"11°"},{"v":30,"d":"30.00`"},"S",{"v":42,"d":"042°"},{"v":33,"d":"33.00`"},"E",{"v":198.49390683680642,"d":"198°"},{"v":284.70279427502004,"d":"284.7"},{"v":1996.74367249179,"d":"1996.7"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.2007128639793479,0.7426375967235872,6.256132703773674,0.02705260340591209,-0.0808802924367075,0.9799247046208296,0.9710624674262374,0.02705260340591209,2.8188130877304314,{"v":161.50609316319358,"d":"161.5"},0.08281668582878603,{"v":284.70279427502004,"d":"284.7"},{"$nulls":47},{"v":198.49390683680642,"d":"198.49391"},{"v":284.70279427502004,"d":"284.7028"}]
["BP 19","MOZAMBIQUE",{"v":16,"d":"16°"},{"v":0,"d":"00.00`"},"S",{"v":41,"d":"041°"},{"v":0,"d":"00.00`"},"E",{"v":208.07751478741096,"d":"208°"},{"v":606.3617142253464,"d":"606.4"},{"v":1712.04087821677,"d":"1712.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.2792526803190927,0.7155849933176751,6.194464403536541,0.08872090364304508,-0.16631654377543895,0.9612616959383189,0.935716845140112,0.08872090364304508,2.651547574772076,{"v":151.92248521258904,"d":"151.9"},0.17638347285448722,{"v":606.3617142253464,"d":"606.4"},{"$nulls":47},{"v":208.07751478741096,"d":"208.07751"},{"v":606.3617142253464,"d":"606.3617"}]
["BP 20","PUNTA ZAVORA",{"v":24,"d":"24°"},{"v":55,"d":"55.00`"},"S",{"v":35,"d":"035°"},{"v":55,"d":"55.00`"},"E",{"v":216.38757082097197,"d":"216°"},{"v":285.70629699954657,"d":"285.7"},{"v":1105.6791639914236,"d":"1105.7"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.4348778719552538,0.62686408967463,6.227916547533099,0.05526875964648714,-0.07499877879860467,0.9069215015644624,0.8920716985642526,0.05526875964648714,2.506509735961216,{"v":143.61242917902803,"d":"143.6"},0.08310859293871473,{"v":285.70629699954657,"d":"285.7"},{"$nulls":47},{"v":216.38757082097197,"d":"216.38757"},{"v":285.70629699954657,"d":"285.7063"}]
["BP 21","CAPE SANTA LUCIA",{"v":28,"d":"28°"},{"v":45,"d":"45.00`"},"S",{"v":32,"d":"032°"},{"v":45,"d":"45.00`"},"E",{"v":216.26875208786186,"d":"216°"},{"v":159.25560973058813,"d":"159.3"},{"v":819.972866991877,"d":"820.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.5017821599483697,0.5715953300281429,6.251594847718489,0.03159045946109729,-0.043054393507114576,0.8767267557075077,0.8675083528120471,0.03159045946109729,2.5085835140670363,{"v":143.73124791213814,"d":"143.7"},0.04632557903449804,{"v":159.25560973058813,"d":"159.3"},{"$nulls":47},{"v":216.26875208786186,"d":"216.26875"},{"v":159.25560973058813,"d":"159.2556"}]
["BP 22","SOUTH OF DURBAN",{"v":30,"d":"30°"},{"v":53.4,"d":"53.40`"},"S",{"v":30,"d":"030°"},{"v":56.4,"d":"56.40`"},"E",{"v":220.19148377714805,"d":"220°"},{"v":208.9300695183834,"d":"208.9"},{"v":660.7172572612889,"d":"660.7"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.5391322059410484,0.5400048705670456,6.23681772671827,0.04636758046131606,-0.054885167381075385,0.858154522511046,0.8458707574071632,0.04636758046131606,2.4401189304166726,{"v":139.80851622285195,"d":"139.8"},0.060775293658607225,{"v":208.9300695183834,"d":"208.9"},{"$nulls":47},{"v":220.19148377714805,"d":"220.19148"},{"v":208.9300695183834,"d":"208.9301"}]
["BP 23","EAST LONDON",{"v":33,"d":"33°"},{"v":33,"d":"33.00`"},"S",{"v":28,"d":"028°"},{"v":17,"d":"17.00`"},"E",{"v":241.18812586085238,"d":"241°"},{"v":87.14863268556118,"d":"87.1"},{"v":451.7871877429055,"d":"451.8"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.5855579640440975,0.49363729010572954,6.256423591982339,0.026761715197246405,-0.014719600647821247,0.8334038487252763,0.8300024610904573,0.026761715197246405,2.0736583941932296,{"v":118.81187413914763,"d":"118.8"},0.02535050964956985,{"v":87.14863268556118,"d":"87.1"},{"$nulls":47},{"v":241.18812586085238,"d":"241.18813"},{"v":87.14863268556118,"d":"87.1486"}]
["BP 24","WEST OF CAPE RECIFE",{"v":34,"d":"34°"},{"v":15,"d":"15.00`"},"S",{"v":26,"d":"026°"},{"v":45,"d":"45.00`"},"E",{"v":256.8308460526402,"d":"257°"},{"v":96.56462732512952,"d":"96.6"},{"v":364.6385550573443,"d":"364.6"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.5977752688080579,0.46687557490848314,6.250024051391694,0.033161255787892197,-0.007759069702215483,0.8265897491271886,0.8247819437449513,0.033161255787892197,1.8006414228783334,{"v":103.16915394735982,"d":"103.2"},0.028089511463079916,{"v":96.56462732512952,"d":"96.6"},{"$nulls":47},{"v":256.8308460526402,"d":"256.83085"},{"v":96.56462732512952,"d":"96.5646"}]
["BP 25","CAPE ST. FRANCIS",{"v":34,"d":"34°"},{"v":37,"d":"37.00`"},"S",{"v":24,"d":"024°"},{"v":51,"d":"51.00`"},"E",{"v":266.3136152805932,"d":"266°"},{"v":124.42614221317564,"d":"124.4"},{"v":268.07392773221477,"d":"268.1"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.6041748093987037,0.43371431912059094,6.239261187671062,0.04392411950852404,-2.8299641509531314E-3,0.8229711546617382,0.8223092396919742,0.04392411950852404,1.6351358776437526,{"v":93.6863847194068,"d":"93.7"},0.03619409761957699,{"v":124.42614221317564,"d":"124.4"},{"$nulls":47},{"v":266.3136152805932,"d":"266.31362"},{"v":124.42614221317564,"d":"124.4261"}]
["BP 26","TSS IN",{"v":34,"d":"34°"},{"v":45,"d":"45.00`"},"S",{"v":22,"d":"022°"},{"v":20,"d":"20.00`"},"E",{"v":261.6093311359798,"d":"262°"},{"v":78.80927292794783,"d":"78.8"},{"v":143.64778551903913,"d":"143.6"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.6065019150680295,0.3897901996120669,6.255550927356342,0.027634379823243516,-0.004076091648164332,0.8216469379421637,0.82069165475275,0.027634379823243516,1.717241124916621,{"v":98.39066886402018,"d":"98.4"},0.022924688228258692,{"v":78.80927292794783,"d":"78.8"},{"$nulls":47},{"v":261.6093311359798,"d":"261.60933"},{"v":78.80927292794783,"d":"78.8093"}]
["BP 27","TSS OUT",{"v":34,"d":"34°"},{"v":56.5,"d":"56.50`"},"S",{"v":20,"d":"020°"},{"v":45,"d":"45.00`"},"E",{"v":245.38441649982087,"d":"245°"},{"v":36.01197839268674,"d":"36.0"},{"v":64.8385125910913,"d":"64.8"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.6098471294676854,0.3621558197888234,6.2715497788329575,0.011635528346628898,-0.005330989305595397,0.8197355828213687,0.8184828143260461,0.011635528346628898,2.0004193061726125,{"v":114.61558350017913,"d":"114.6"},0.010475459885157318,{"v":36.01197839268674,"d":"36.0"},{"$nulls":47},{"v":245.38441649982087,"d":"245.38442"},{"v":36.01197839268674,"d":"36.0120"}]
["BP 28","CAPE AGULHAS",{"v":35,"d":"35°"},{"v":11.5,"d":"11.50`"},"S",{"v":20,"d":"020°"},{"v":5,"d":"05.00`"},"E",{"v":276.9738260454326,"d":"277°"},{"v":28.826534198407362,"d":"28.8"},{"v":28.82653419840456,"d":"28.8"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.6142104525976712,0.3505202914421945,6.273004219876286,0.010181087303300251,1.2453595392335512E-3,0.8172287283738303,0.8175219270064169,0.010181087303300251,1.4490801008407628,{"v":83.02617395456744,"d":"83.0"},0.00838529889501588,{"v":28.826534198407362,"d":"28.8"},{"$nulls":47},{"v":276.9738260454326,"d":"276.97383"},{"v":28.826534198407362,"d":"28.8265"}]
["BP 29","QUOIN POINT",{"v":35,"d":"35°"},{"v":8,"d":"08.00`"},"S",{"v":19,"d":"019°"},{"v":30,"d":"30.00`"},"E","",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.6131923438673411,0.34033920413889424,5.942846103040692,0.34033920413889424,0.6556797708118176,0.8178150544913865,0.9352009489451361,0.34033920413889424,0.47878156061731747,{"v":27.43216273205928,"d":"27.4"},0.6908766458630974,{"v":2375.0589583265933,"d":"2375.1"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["BP 30",{"$nulls":7},{"$f":"IF(C39=\"\",\"\",IF(AD39<AC39,360-AJ39,AJ39))","v":""},{"$f":"IF(C39=\"\",0,+AL39)","v":{"v":0,"d":"0.0"}},{"$f":"+K38-J38","v":{"v":-2.8030910925735952E-12,"d":"-0.0"}},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,1,1,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
[" ",null," "," "," ","TOTAL DISTANCE:",{"$nulls":3},{"$f":"SUM(J10:J39)","v":{"v":16016.103436472162,"d":"16016.1"}},null," ",{"$nulls":15}," "," "," "," "," "," ",null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," ",null," "," "]

{"sheet":"Sea Passage Safety Setting","index":8,"n_rows":31,"n_cols":8,"rows_kept":31,"merged":[[0,0,0,4],[1,3,1,4],[16,0,16,4],[17,0,17,4],[18,0,18,4],[19,0,19,4],[20,0,20,4],[21,0,21,4],[22,0,22,4],[23,0,23,4],[24,0,24,4],[26,1,26,3],[27,1,27,3],[28,1,29,3],[30,1,30,3]]}
["Safety Setting Sea Passage"]
["Beam:",32,"Cb:",0.7786]
["AREA","Ocean Passage (Open)","Fairways outside ports (Coastal / Shallow waters)","Fairways inside ports (Within Port Limits / Restricted Waters)","Remarks"]
["MAX. SPEED",{"v":12.5,"d":"12.50"},{"v":12.5,"d":"12.50"},{"v":6,"d":"6.00"}]
["DEEPEST DRAFT",{"v":20,"d":"20.00"},{"v":4.9,"d":"4.90"},{"v":19.8,"d":"19.80"},"Static Draft"]
["TOTAL CALCULATED SQUAT",1.25,1.16,0.56]
["SAFETY MARGIN",{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},1.42,"Ensure it is equal to A3 in NAV 02 (Catzoc Consideration Tab)."]
["MINIMUM UKC REQUIRED",{"$f":"(B5+B6+B7)/2","v":{"v":11.625,"d":"11.63"}},{"$f":"(C5+C6+C7)*0.15","v":{"v":1.209,"d":"1.21"}},{"$f":"IF(F8>G8,F8,G8)","v":{"v":0.6,"d":"0.60"}},null,{"$f":"B2*0.015","v":0.48},0.6]
["TIDE",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["SAFETY DEPTH",{"$f":"IF((B5+B6+B8+B7-B9)<B5,ROUNDUP(B5,0),ROUNDUP((B5+B6+B8+B7-B9),0))","v":{"v":35,"d":"35.00"}},{"$f":"IF((C5+C6+C8+C7-C9)<C5,ROUNDUP(C5,0),ROUNDUP((C5+C6+C8+C7-C9),0))","v":{"v":10,"d":"10.00"}},{"$f":"IF((D5+D6+D8+D7-D9)<D5,ROUNDUP(D5,0),ROUNDUP((D5+D6+D8+D7-D9),0))","v":{"v":23,"d":"23.00"}}]
["SAFETY CONTOUR",{"$f":"B10","v":{"v":35,"d":"35.00"}},{"$f":"C10","v":{"v":10,"d":"10.00"}},{"$f":"D10","v":{"v":23,"d":"23.00"}}]
["SHALLOW CONTOUR",{"$f":"IF(ROUNDUP((B5+1),0)>=B11,B5,ROUNDUP((B5+1),0))","v":{"v":21,"d":"21.00"}},{"$f":"IF(ROUNDUP((C5+1),0)>=C11,C5,ROUNDUP((C5+1),0))","v":{"v":6,"d":"6.00"}},{"v":21,"d":"21.00"}]
["DEEP CONTOUR",{"$f":"ROUNDUP((F13*2),0)","v":{"v":43,"d":"43.00"}},{"$f":"ROUNDUP((G13*2),0)","v":{"v":13,"d":"13.00"}},{"$f":"ROUNDUP((H13*2),0)","v":{"v":41,"d":"41.00"}},null,{"$f":"B5+B6","v":21.25},{"$f":"C5+C6","v":{"v":6.0600000000000005,"d":"6.06"}},{"$f":"D5+D6","v":20.36}]
["Look Ahead Settings",{"$nulls":3},"FOM 3.29 Section 5.6"]
["Cross Track Distance",{"$nulls":3},"FOM 3.29 Section 5.8"]
[]
["SHALLOW CONTOUR = Next contour shallower than safety contour/must not be less than vessel’s draft"]
["SAFETY DEPTH = Vessel Draft + Dynamic Squat + UKC + Safety Margin - Height of Tide"]
["SAFETY CONTOUR = Safety contour should be set at a value equal to the safety depth"]
["DEPTH CONTOUR = Twice the Dynamic Draft (Max. Static draft + Squat)"]
["ECHO SOUNDER = Ensure alarm, if fitted, is used for safe navigation. "]
["NOTE (when marking NO GO AREA on ECDIS):"]
[]
["Shallow Contour should not be confused by the wording 'contour'. The safe/unsafe contour for Navigation is the safety contour. A shallow contour is only for additional indication of the underwater topography of the already 'un-safe' water; it is not calculation between draft and tide values. Reminding once again that the safety of the navigation is only to be dependent upon the 'Safety Contour' & 'Safety Depth' mentioned above."]
["All ECDIS parameters set prior to the beginning of the voyage must not be removed/changed/de-activated without permission from the Master. Any safety parameters to be re-set to original settings after planning/trial/simulation mode"]
[]
["Prepared by :"]
[null,"Second Officer"]
[]
["Calculation confirmed by :"]
[null,"Master"]

{"sheet":"Sea Passage","index":9,"n_rows":109,"n_cols":87,"rows_kept":109,"merged":[[2,1,2,2],[3,7,3,9],[4,1,4,2],[4,6,4,9],[4,12,4,14],[5,7,5,12],[6,0,8,0],[6,1,8,1],[6,2,7,4],[6,5,7,7],[6,8,8,8],[6,9,8,9],[6,10,8,10],[6,11,8,11],[6,12,7,15],[6,16,8,16],[6,17,8,17],[6,18,8,18],[6,19,8,19],[6,20,7,20],[6,21,8,21],[6,22,8,22],[6,23,7,24],[108,5,108,7]]}
[]
[{"$nulls":16},"`"]
[null,"All dates & times are GMT",{"$nulls":9},{"$f":"+'Vsl Details'!C7","v":"M/T Example"}]
[null,"PILOTS",null,"SPD"," ","Voy :",{"$f":"+'Vsl Details'!C9","v":11},{"$f":"+'Vsl Details'!C10","v":"Loaded"},null,null,"Time",{"$nulls":11},{"$f":"SUM(J10:J108)","v":{"v":16016.103436472162,"d":"Total Distance : 16016.1"}}]
[null,"2005-07-22T12:00:00",null,14.3," ","From :",{"$f":"'Checklist A'!$G$8","v":"Singapore"},{"$nulls":3},{"$f":"+'Vsl Details'!C14","v":{"v":8,"d":" 8"}},"To :",{"$f":"'Checklist A'!$G$9","v":"Rotterdam"},null,null,{"$f":"+'Vsl Details'!C18","v":{"v":1,"d":" 1"}},{"$nulls":6},"Sea Passage"]
[{"$nulls":3}," "," "," "]
["WP No.","GEOGRAPHICAL AREA WAYPOINT","LATITUDE",null,null,"LONGITUDE",null,null,"CO","DIST. TO NEXT WP","DTG","RL/GC","Verification Freq / Method",{"$nulls":3},"Max Spd (kts)","T&P Notices","Safety Setting","UKC","MARPOL Special area / ECA Zone","Security Level","Remarks: NAV Aids, Restrictions, Weather, Cautions, Traffic Density, UKC, Tides etc, T&P notice number effecting each leg, extra lookout if passing through HRA, Area where vessel should be hardened.","Watch Level",{"$nulls":24},"Ocean Passage (Open)","Fairways outside ports (Coastal / Shallow waters)","Fairways inside ports (Within Port Limits / Restricted Waters)"]
[{"$nulls":26},"latrad","longrad","dlon_W","dlon_E","dphi","q1","q","dlon_min","tc_rad","tc","dist_rad","dist"]
[null,null,"DEG","MIN","N/S","DEG","MIN","E/W",{"$nulls":4},"Freq","Main","Alt 1","Alt 2",{"$nulls":4},"Yes / No",null,null,"Bridge","E/R",{"$nulls":60},"Course","Distance"]
["WP 1","PILOT STATION",{"v":27,"d":"27°"},{"v":0,"d":"00.00`"},"S",{"v":160,"d":"160°"},{"v":9,"d":"09.00`"},"E",{"$f":"IF(C11=\"\",\"\",IF(AD10<AC10,360-AJ10,AJ10))","v":{"v":27.7622246258402,"d":"028°"}},{"$f":"IF(C11=\"\",0,+AL10)","v":{"v":3674.4751808764377,"d":"3674.5"}},{"$f":"+J109","v":{"v":16016.103436472162,"d":"16016.1"}},null,"< 1 h","Vis","Rdr","Cel",null,null,"Ocean Passage (Open)",{"$nulls":7},{"$f":"IF(E10=\"N\",RADIANS(C10+(D10/60)),-RADIANS(C10+(D10/60)))","v":-0.47123889803846897},{"$f":"IF(H10=\"E\",+RADIANS(F10+(G10/60)),-RADIANS(F10+(G10/60)))","v":2.795144797068919},{"$f":"MOD(AB11-AB10,2*PI())","v":0.517548300858051},{"$f":"MOD(AB10-AB11,2*PI())","v":5.765637006321535},{"$f":"LN(TAN(AA11/2+PI()/4)/TAN(AA10/2+PI()/4))","v":0.9831883810571177},{"$f":"COS(AA10)","v":0.8910065241883679},{"$f":"IF(AA11=AA10,AF10,(AA11-AA10)/AE10)","v":0.9619957158765963},{"$f":"MIN(AC10,AD10)","v":0.517548300858051},{"$f":"MOD(ATAN2(AE10,AH10),2*PI())","v":0.4845422273991623},{"$f":"DEGREES(AI10)","v":{"v":27.7622246258402,"d":"27.8"}},{"$f":"SQRT(AG10^2*AH10^2+(AA11-AA10)^2)","v":1.0688615031518003},{"$f":"DEGREES(AK10)*60","v":{"v":3674.4751808764377,"d":"3674.5"}},{"$nulls":47},{"$f":"I10","v":{"v":27.7622246258402,"d":"27.76222"}},{"$f":"J10","v":{"v":3674.4751808764377,"d":"3674.4752"}}]
["WP 2","GHAR BUOY",{"v":27,"d":"27°"},{"v":11.5,"d":"11.50`"},"N",{"v":170,"d":"170°"},{"v":11.8,"d":"11.80`"},"W",{"v":269.9992267849206,"d":"270°"},{"v":7410.070113943125,"d":"7410.1"},{"$f":"+K10-J10","v":{"v":12341.628255595724,"d":"12341.6"}},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.47458411243812476,-2.970492209252616,{"$f":"MOD(AB12-AB11,2*PI())","v":3.8598829072480596},{"$f":"MOD(AB11-AB12,2*PI())","v":2.4233023999315266},{"$f":"LN(TAN(AA12/2+PI()/4)/TAN(AA11/2+PI()/4))","v":-3.2702826867868676E-5},{"$f":"COS(AA11)","v":0.8894828460823052},{"$f":"IF(AA12=AA11,AF11,(AA12-AA11)/AE11)","v":0.889489492271762},{"$f":"MIN(AC11,AD11)","v":2.4233023999315266},{"$f":"MOD(ATAN2(AE11,AH11),2*PI())","v":1.570809821943858},{"$f":"DEGREES(AI11)","v":{"v":90.00077321507939,"d":"90.0"}},{"$f":"SQRT(AG11^2*AH11^2+(AA12-AA11)^2)","v":2.155502021532315},{"$f":"DEGREES(AK11)*60","v":{"v":7410.070113943125,"d":"7410.1"}},{"$nulls":47},{"v":269.9992267849206,"d":"269.99923"},{"v":7410.070113943125,"d":"7410.0701"}]
["WP 3","RAS TANNURAH RACON (K)",{"v":27,"d":"27°"},{"v":11.4,"d":"11.40`"},"N",{"v":50,"d":"050°"},{"v":57.5,"d":"57.50`"},"E",{"v":98.89184782811951,"d":"099°"},{"v":60.81394329207227,"d":"60.8"},{"$f":"+K11-J11","v":{"v":4931.558141652599,"d":"4931.6"}},null,"< 1 h","Vis","Gps","Gps",{"$nulls":10},0.4745550236172582,0.8893906979954438,0.019634954084936207,{"$f":"MOD(AB12-AB13,2*PI())","v":6.26355035309465},{"$f":"LN(TAN(AA13/2+PI()/4)/TAN(AA12/2+PI()/4))","v":-3.0718896058628425E-3},{"$f":"COS(AA12)","v":0.8894961383826187},{"$f":"IF(AA13=AA12,AF12,(AA13-AA12)/AE12)","v":0.89011960463655},{"$f":"MIN(AC12,AD12)","v":0.019634954084936207},{"$f":"MOD(ATAN2(AE12,AH12),2*PI())","v":1.7259883479818887},{"v":98.89184782811951,"d":"98.9"},{"$f":"SQRT(AG12^2*AH12^2+(AA13-AA12)^2)","v":0.017690059026129676},{"v":60.81394329207227,"d":"60.8"},{"$nulls":47},{"v":98.89184782811951,"d":"98.89185"},{"v":60.81394329207227,"d":"60.8139"}]
["WP 4","FIELD",{"v":27,"d":"27°"},{"v":2,"d":"02.00`"},"N",{"v":52,"d":"052°"},{"v":5,"d":"05.00`"},"E",{"v":131.88581763263926,"d":"132°"},{"v":29.955891612915163,"d":"30.0"},{"v":4870.744198360527,"d":"4870.7"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.47182067445580045,0.90902565208038,0.007272205216643068,6.275913101962943,-0.006521728036198491,0.8907422524501034,0.8920586907370712,0.007272205216643068,2.3018417543743483,{"v":131.88581763263926,"d":"131.9"},0.008713815650265406,{"v":29.955891612915163,"d":"30.0"},{"$nulls":31},"Yes",{"$nulls":15},{"v":131.88581763263926,"d":"131.88582"},{"v":29.955891612915163,"d":"29.9559"}]
["WP 5","CABLE BANK",{"v":26,"d":"26°"},{"v":42,"d":"42.00`"},"N",{"v":52,"d":"052°"},{"v":30,"d":"30.00`"},"E",{"v":106.49874610577218,"d":"106°"},{"v":104.5795411838232,"d":"104.6"},{"v":4840.788306747611,"d":"4840.8"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.46600291028248597,0.9162978572970231,0.03257947937056083,6.250605827809025,-0.009649705905783667,0.8933713883278376,0.8952998030949143,0.03257947937056083,1.858753768791214,{"v":106.49874610577218,"d":"106.5"},0.030420955398045384,{"v":104.5795411838232,"d":"104.6"},{"$nulls":31},"No",{"$nulls":15},{"v":106.49874610577218,"d":"106.49875"},{"v":104.5795411838232,"d":"104.5795"}]
["WP 6","FORUR ISLAND",{"v":26,"d":"26°"},{"v":12.3,"d":"12.30`"},"N",{"v":54,"d":"054°"},{"v":22,"d":"22.00`"},"E",{"v":96.64091344577552,"d":"097°"},{"v":50.15285243581551,"d":"50.2"},{"v":4736.208765563788,"d":"4736.2"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.457363530485114,0.9488773366675839,0.016144295580947432,6.267041011598639,-1.8796422586359032E-3,0.8972198376038806,0.897591870213388,0.016144295580947432,1.6867021317636413,{"v":96.64091344577552,"d":"96.6"},0.014588873404530646,{"v":50.15285243581551,"d":"50.2"},{"$nulls":31},"Level 1",{"$nulls":15},{"v":96.64091344577552,"d":"96.64091"},{"v":50.15285243581551,"d":"50.1529"}]
["WP 7","TONBE ISLAND",{"v":26,"d":"26°"},{"v":6.5,"d":"06.50`"},"N",{"v":55,"d":"055°"},{"v":17.5,"d":"17.50`"},"E",{"v":70.38069863120359,"d":"070°"},{"v":11.912955468934165,"d":"11.9"},{"v":4686.055913127972,"d":"4686.1"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.4556763788748529,0.9650216322485313,3.6361026083215897E-3,6.279549204571264,1.2961382792950143E-3,0.8979635797038885,0.8977073304985035,3.6361026083215897E-3,1.228374920968369,{"v":70.38069863120359,"d":"70.4"},0.003465338276272771,{"v":11.912955468934165,"d":"11.9"},{"$nulls":31},"Level 2",{"$nulls":15},{"v":70.38069863120359,"d":"70.38070"},{"v":11.912955468934165,"d":"11.9130"}]
["WP 8","TSS OUT",{"v":26,"d":"26°"},{"v":10.5,"d":"10.50`"},"N",{"v":55,"d":"055°"},{"v":30,"d":"30.00`"},"E",{"v":66.65374013681041,"d":"067°"},{"v":51.73019652138883,"d":"51.7"},{"v":4674.142957659038,"d":"4674.1"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.45683993170951576,0.9686577348568529,0.015417075059283247,6.267768232120303,0.006654402881355833,0.8974509275255026,0.8961297330456026,0.015417075059283247,1.1633272241560373,{"v":66.65374013681041,"d":"66.7"},0.015047704200032538,{"v":51.73019652138883,"d":"51.7"},{"$nulls":31},"Level 3",{"$nulls":15},{"v":66.65374013681041,"d":"66.65374"},{"v":51.73019652138883,"d":"51.7302"}]
["WP 9","TSS HORMUZ 1",{"v":26,"d":"26°"},{"v":31,"d":"31.00`"},"N",{"v":56,"d":"056°"},{"v":23,"d":"23.00`"},"E",{"v":65.17850251325903,"d":"065°"},{"v":5.717108158419505,"d":"5.7"},{"v":4622.412761137649,"d":"4622.4"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.46280313998716305,0.9840748099161362,1.6871516102611173E-3,6.2814981555693254,7.8034179774028913E-4,0.8948045300584291,0.8946486050335065,1.6871516102611173E-3,1.1375794703757691,{"v":65.17850251325903,"d":"65.2"},1.6630393509508323E-3,{"v":5.717108158419505,"d":"5.7"},{"$nulls":47},{"v":65.17850251325903,"d":"65.17850"},{"v":5.717108158419505,"d":"5.7171"}]
["WP 10","TSS HORMUZ 2",{"v":26,"d":"26°"},{"v":33.4,"d":"33.40`"},"N",{"v":56,"d":"056°"},{"v":28.8,"d":"28.80`"},"E",{"v":90,"d":"090°"},{"v":3.5779705018346784,"d":"3.6"},{"v":4616.69565297923,"d":"4616.7"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.46350127168796074,0.9857619615263973,1.163552834662962E-3,6.282021754344923,0,0.8944926254586114,0.8944926254586114,1.163552834662962E-3,1.5707963267948966,{"v":90,"d":"90.0"},1.0407894299374826E-3,{"v":3.5779705018346784,"d":"3.6"},{"$nulls":47},{"v":90,"d":"90.00000"},{"v":3.5779705018346784,"d":"3.5780"}]
["WP 11","TSS HORMUZ 3",{"v":26,"d":"26°"},{"v":33.4,"d":"33.40`"},"N",{"v":56,"d":"056°"},{"v":32.8,"d":"32.80`"},"E",{"v":149.3791183222242,"d":"149°"},{"v":62.05287305205036,"d":"62.1"},{"v":4613.117682477395,"d":"4613.1"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.46350127168796074,0.9869255143610602,0.010239264945033355,6.272946042234553,-0.01729925893452955,0.8944926254586114,0.8979246106169625,0.010239264945033355,2.607157448449,{"v":149.3791183222242,"d":"149.4"},0.01805044908467236,{"v":62.05287305205036,"d":"62.1"},{"$nulls":47},{"v":149.3791183222242,"d":"149.37912"},{"v":62.05287305205036,"d":"62.0529"}]
["WP 12","RAS AL KUH 1",{"v":25,"d":"25°"},{"v":40,"d":"40.00`"},"N",{"v":57,"d":"057°"},{"v":8,"d":"08.00`"},"E",{"v":140.00938056519738,"d":"140°"},{"v":13.052279960938492,"d":"13.1"},{"v":4551.064809425345,"d":"4551.1"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.4479678413452113,0.9971647793060936,2.7052603405912645E-3,6.280480046838995,-0.00322507590361609,0.9013291614454622,0.9019577131179077,2.7052603405912645E-3,2.4436246745404535,{"v":140.00938056519738,"d":"140.0"},3.7967543368408923E-3,{"v":13.052279960938492,"d":"13.1"},{"$nulls":47},{"v":140.00938056519738,"d":"140.00938"},{"v":13.052279960938492,"d":"13.0523"}]
["WP 13","RAS AL KUH 2",{"v":25,"d":"25°"},{"v":30,"d":"30.00`"},"N",{"v":57,"d":"057°"},{"v":17.3,"d":"17.30`"},"E",{"v":136.30273186512736,"d":"136°"},{"v":124.48131292684803,"d":"124.5"},{"v":4538.012529464406,"d":"4538.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.44505895925855404,0.9998700396466849,0.02754711336064375,6.2556381938189425,-0.02882915937034003,0.9025852843498606,0.9081062143924088,0.02754711336064375,2.378931450509464,{"v":136.30273186512736,"d":"136.3"},0.03621014612964796,{"v":124.48131292684803,"d":"124.5"},{"$nulls":47},{"v":136.30273186512736,"d":"136.30273"},{"v":124.48131292684803,"d":"124.4813"}]
["WP 14","24° NORTH",{"v":24,"d":"24°"},{"v":0,"d":"00.00`"},"N",{"v":58,"d":"058°"},{"v":52,"d":"52.00`"},"E",{"v":136.39000837687638,"d":"136°"},{"v":110.48936444860492,"d":"110.5"},{"v":4413.531216537558,"d":"4413.5"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.4188790204786391,1.0274171530073286,0.024143721319255018,6.259041585860331,-0.025344553488278247,0.9135454576426009,0.9181876770494501,0.024143721319255018,2.38045471299914,{"v":136.39000837687638,"d":"136.4"},0.03214005330106875,{"v":110.48936444860492,"d":"110.5"},{"$nulls":47},{"v":136.39000837687638,"d":"136.39001"},{"v":110.48936444860492,"d":"110.4894"}]
["WP 15","RAS AL HADD",{"v":22,"d":"22°"},{"v":40,"d":"40.00`"},"N",{"v":60,"d":"060°"},{"v":15,"d":"15.00`"},"E",{"v":180,"d":"180°"},{"v":40.00000000000012,"d":"40.0"},{"v":4303.041852088953,"d":"4303.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.3956079637853814,1.0515608743265836,0,0,-0.012579196741493666,0.9227624443554423,0.9249818240180641,0,3.141592653589793,{"v":180,"d":"180.0"},0.011635528346628898,{"v":40.00000000000012,"d":"40.0"},{"$nulls":47},{"v":180,"d":"180.00000"},{"v":40.00000000000012,"d":"40.0000"}]
["WP 16","RAS QUMAYLAH",{"v":22,"d":"22°"},{"v":0,"d":"00.00`"},"N",{"v":60,"d":"060°"},{"v":15,"d":"15.00`"},"E",{"v":204.09544375790784,"d":"204°"},{"v":618.9293944162871,"d":"618.9"},{"v":4263.041852088953,"d":"4263.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.3839724354387525,1.0515608743265836,6.20609993188317,0.07708537529641624,-0.17236328619713176,0.9271838545667874,0.9535199839956845,0.07708537529641624,2.721047825285186,{"v":155.90455624209216,"d":"155.9"},0.1800392628323136,{"v":618.9293944162871,"d":"618.9"},{"$nulls":47},{"v":204.09544375790784,"d":"204.09544"},{"v":618.9293944162871,"d":"618.9294"}]
["WP 17","SUQUTRA",{"v":12,"d":"12°"},{"v":35,"d":"35.00`"},"N",{"v":55,"d":"055°"},{"v":50,"d":"50.00`"},"E",{"v":208.69878397038536,"d":"209°"},{"v":1647.368785180876,"d":"1647.4"},{"v":3644.112457672666,"d":"3644.1"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.2196205975426198,0.9744754990301674,6.051347404873006,0.2318379023065802,-0.4234819293166806,0.9759801759455132,0.9925652841910086,0.2318379023065802,2.6407043819879976,{"v":151.30121602961464,"d":"151.3"},0.4792001549330909,{"v":1647.368785180876,"d":"1647.4"},{"$nulls":47},{"v":208.69878397038536,"d":"208.69878"},{"v":1647.368785180876,"d":"1647.3688"}]
["WP 18","COMORES",{"v":11,"d":"11°"},{"v":30,"d":"30.00`"},"S",{"v":42,"d":"042°"},{"v":33,"d":"33.00`"},"E",{"v":198.49390683680642,"d":"198°"},{"v":284.70279427502004,"d":"284.7"},{"v":1996.74367249179,"d":"1996.7"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.2007128639793479,0.7426375967235872,6.256132703773674,0.02705260340591209,-0.0808802924367075,0.9799247046208296,0.9710624674262374,0.02705260340591209,2.8188130877304314,{"v":161.50609316319358,"d":"161.5"},0.08281668582878603,{"v":284.70279427502004,"d":"284.7"},{"$nulls":47},{"v":198.49390683680642,"d":"198.49391"},{"v":284.70279427502004,"d":"284.7028"}]
["WP 19","MOZAMBIQUE",{"v":16,"d":"16°"},{"v":0,"d":"00.00`"},"S",{"v":41,"d":"041°"},{"v":0,"d":"00.00`"},"E",{"v":208.07751478741096,"d":"208°"},{"v":606.3617142253464,"d":"606.4"},{"v":1712.04087821677,"d":"1712.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.2792526803190927,0.7155849933176751,6.194464403536541,0.08872090364304508,-0.16631654377543895,0.9612616959383189,0.935716845140112,0.08872090364304508,2.651547574772076,{"v":151.92248521258904,"d":"151.9"},0.17638347285448722,{"v":606.3617142253464,"d":"606.4"},{"$nulls":47},{"v":208.07751478741096,"d":"208.07751"},{"v":606.3617142253464,"d":"606.3617"}]
["WP 20","PUNTA ZAVORA",{"v":24,"d":"24°"},{"v":55,"d":"55.00`"},"S",{"v":35,"d":"035°"},{"v":55,"d":"55.00`"},"E",{"v":216.38757082097197,"d":"216°"},{"v":285.70629699954657,"d":"285.7"},{"v":1105.6791639914236,"d":"1105.7"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.4348778719552538,0.62686408967463,6.227916547533099,0.05526875964648714,-0.07499877879860467,0.9069215015644624,0.8920716985642526,0.05526875964648714,2.506509735961216,{"v":143.61242917902803,"d":"143.6"},0.08310859293871473,{"v":285.70629699954657,"d":"285.7"},{"$nulls":47},{"v":216.38757082097197,"d":"216.38757"},{"v":285.70629699954657,"d":"285.7063"}]
["WP 21","CAPE SANTA LUCIA",{"v":28,"d":"28°"},{"v":45,"d":"45.00`"},"S",{"v":32,"d":"032°"},{"v":45,"d":"45.00`"},"E",{"v":216.26875208786186,"d":"216°"},{"v":159.25560973058813,"d":"159.3"},{"v":819.972866991877,"d":"820.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.5017821599483697,0.5715953300281429,6.251594847718489,0.03159045946109729,-0.043054393507114576,0.8767267557075077,0.8675083528120471,0.03159045946109729,2.5085835140670363,{"v":143.73124791213814,"d":"143.7"},0.04632557903449804,{"v":159.25560973058813,"d":"159.3"},{"$nulls":47},{"v":216.26875208786186,"d":"216.26875"},{"v":159.25560973058813,"d":"159.2556"}]
["WP 22","SOUTH OF DURBAN",{"v":30,"d":"30°"},{"v":53.4,"d":"53.40`"},"S",{"v":30,"d":"030°"},{"v":56.4,"d":"56.40`"},"E",{"v":220.19148377714805,"d":"220°"},{"v":208.9300695183834,"d":"208.9"},{"v":660.7172572612889,"d":"660.7"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.5391322059410484,0.5400048705670456,6.23681772671827,0.04636758046131606,-0.054885167381075385,0.858154522511046,0.8458707574071632,0.04636758046131606,2.4401189304166726,{"v":139.80851622285195,"d":"139.8"},0.060775293658607225,{"v":208.9300695183834,"d":"208.9"},{"$nulls":47},{"v":220.19148377714805,"d":"220.19148"},{"v":208.9300695183834,"d":"208.9301"}]
["WP 23","EAST LONDON",{"v":33,"d":"33°"},{"v":33,"d":"33.00`"},"S",{"v":28,"d":"028°"},{"v":17,"d":"17.00`"},"E",{"v":241.18812586085238,"d":"241°"},{"v":87.14863268556118,"d":"87.1"},{"v":451.7871877429055,"d":"451.8"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.5855579640440975,0.49363729010572954,6.256423591982339,0.026761715197246405,-0.014719600647821247,0.8334038487252763,0.8300024610904573,0.026761715197246405,2.0736583941932296,{"v":118.81187413914763,"d":"118.8"},0.02535050964956985,{"v":87.14863268556118,"d":"87.1"},{"$nulls":47},{"v":241.18812586085238,"d":"241.18813"},{"v":87.14863268556118,"d":"87.1486"}]
["WP 24","WEST OF CAPE RECIFE",{"v":34,"d":"34°"},{"v":15,"d":"15.00`"},"S",{"v":26,"d":"026°"},{"v":45,"d":"45.00`"},"E",{"v":256.8308460526402,"d":"257°"},{"v":96.56462732512952,"d":"96.6"},{"v":364.6385550573443,"d":"364.6"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.5977752688080579,0.46687557490848314,6.250024051391694,0.033161255787892197,-0.007759069702215483,0.8265897491271886,0.8247819437449513,0.033161255787892197,1.8006414228783334,{"v":103.16915394735982,"d":"103.2"},0.028089511463079916,{"v":96.56462732512952,"d":"96.6"},{"$nulls":47},{"v":256.8308460526402,"d":"256.83085"},{"v":96.56462732512952,"d":"96.5646"}]
["WP 25","CAPE ST. FRANCIS",{"v":34,"d":"34°"},{"v":37,"d":"37.00`"},"S",{"v":24,"d":"024°"},{"v":51,"d":"51.00`"},"E",{"v":266.3136152805932,"d":"266°"},{"v":124.42614221317564,"d":"124.4"},{"v":268.07392773221477,"d":"268.1"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.6041748093987037,0.43371431912059094,6.239261187671062,0.04392411950852404,-2.8299641509531314E-3,0.8229711546617382,0.8223092396919742,0.04392411950852404,1.6351358776437526,{"v":93.6863847194068,"d":"93.7"},0.03619409761957699,{"v":124.42614221317564,"d":"124.4"},{"$nulls":47},{"v":266.3136152805932,"d":"266.31362"},{"v":124.42614221317564,"d":"124.4261"}]
["WP 26","TSS IN",{"v":34,"d":"34°"},{"v":45,"d":"45.00`"},"S",{"v":22,"d":"022°"},{"v":20,"d":"20.00`"},"E",{"v":261.6093311359798,"d":"262°"},{"v":78.80927292794783,"d":"78.8"},{"v":143.64778551903913,"d":"143.6"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.6065019150680295,0.3897901996120669,6.255550927356342,0.027634379823243516,-0.004076091648164332,0.8216469379421637,0.82069165475275,0.027634379823243516,1.717241124916621,{"v":98.39066886402018,"d":"98.4"},0.022924688228258692,{"v":78.80927292794783,"d":"78.8"},{"$nulls":47},{"v":261.6093311359798,"d":"261.60933"},{"v":78.80927292794783,"d":"78.8093"}]
["WP 27","TSS OUT",{"v":34,"d":"34°"},{"v":56.5,"d":"56.50`"},"S",{"v":20,"d":"020°"},{"v":45,"d":"45.00`"},"E",{"v":245.38441649982087,"d":"245°"},{"v":36.01197839268674,"d":"36.0"},{"v":64.8385125910913,"d":"64.8"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.6098471294676854,0.3621558197888234,6.2715497788329575,0.011635528346628898,-0.005330989305595397,0.8197355828213687,0.8184828143260461,0.011635528346628898,2.0004193061726125,{"v":114.61558350017913,"d":"114.6"},0.010475459885157318,{"v":36.01197839268674,"d":"36.0"},{"$nulls":47},{"v":245.38441649982087,"d":"245.38442"},{"v":36.01197839268674,"d":"36.0120"}]
["WP 28","CAPE AGULHAS",{"v":35,"d":"35°"},{"v":11.5,"d":"11.50`"},"S",{"v":20,"d":"020°"},{"v":5,"d":"05.00`"},"E",{"v":276.9738260454326,"d":"277°"},{"v":28.826534198407362,"d":"28.8"},{"v":28.82653419840456,"d":"28.8"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.6142104525976712,0.3505202914421945,6.273004219876286,0.010181087303300251,1.2453595392335512E-3,0.8172287283738303,0.8175219270064169,0.010181087303300251,1.4490801008407628,{"v":83.02617395456744,"d":"83.0"},0.00838529889501588,{"v":28.826534198407362,"d":"28.8"},{"$nulls":47},{"v":276.9738260454326,"d":"276.97383"},{"v":28.826534198407362,"d":"28.8265"}]
["WP 29","QUOIN POINT",{"v":35,"d":"35°"},{"v":8,"d":"08.00`"},"S",{"v":19,"d":"019°"},{"v":30,"d":"30.00`"},"E","",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.6131923438673411,0.34033920413889424,5.942846103040692,0.34033920413889424,0.6556797708118176,0.8178150544913865,0.9352009489451361,0.34033920413889424,0.47878156061731747,{"v":27.43216273205928,"d":"27.4"},0.6908766458630974,{"v":2375.0589583265933,"d":"2375.1"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 30",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 31",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 32",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 33",{"$nulls":7},{"$f":"IF(C43=\"\",\"\",IF(AD42<AC42,360-AJ42,AJ42))","v":""},{"$f":"IF(C43=\"\",0,+AL42)","v":{"v":0,"d":"0.0"}},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},{"$f":"IF(E42=\"N\",RADIANS(C42+(D42/60)),-RADIANS(C42+(D42/60)))","v":0},{"$f":"IF(H42=\"E\",+RADIANS(F42+(G42/60)),-RADIANS(F42+(G42/60)))","v":0},0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},{"$f":"I42","v":""},{"$f":"J42","v":{"v":0,"d":"0.0000"}}]
["WP 34",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 35",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 36",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 37",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 38",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 39",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 40",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 41",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 42",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 43",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 44",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 45",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 46",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 47",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 48",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 49",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 50",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 51",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 52",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 53",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 54",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 55",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 56",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 57",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 58",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 59",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 60",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 61",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 62",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 63",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 64",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 65",{"$nulls":7},{"$f":"IF(C75=\"\",\"\",IF(AD74<AC74,360-AJ74,AJ74))","v":""},{"$f":"IF(C75=\"\",0,+AL74)","v":{"v":0,"d":"0.0"}},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},{"$f":"IF(E74=\"N\",RADIANS(C74+(D74/60)),-RADIANS(C74+(D74/60)))","v":0},{"$f":"IF(H74=\"E\",+RADIANS(F74+(G74/60)),-RADIANS(F74+(G74/60)))","v":0},0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},{"$f":"I74","v":""},{"$f":"J74","v":{"v":0,"d":"0.0000"}}]
["WP 66",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,{"$f":"MOD(AB76-AB75,2*PI())","v":0},0,0,1,1,0,{"$error":"#DIV/0!"},{"$f":"DEGREES(AI75)","v":{"$error":"#DIV/0!"}},0,{"$f":"DEGREES(AK75)*60","v":{"v":0,"d":"0.0"}},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 67",{"$nulls":7},"",{"v":0,"d":"0.0"},{"$f":"+K75-J75","v":{"v":-2.8030910925735952E-12,"d":"-0.0"}},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,{"$f":"MOD(AB76-AB77,2*PI())","v":0},{"$f":"LN(TAN(AA77/2+PI()/4)/TAN(AA76/2+PI()/4))","v":0},{"$f":"COS(AA76)","v":1},{"$f":"IF(AA77=AA76,AF76,(AA77-AA76)/AE76)","v":1},{"$f":"MIN(AC76,AD76)","v":0},{"$f":"MOD(ATAN2(AE76,AH76),2*PI())","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"SQRT(AG76^2*AH76^2+(AA77-AA76)^2)","v":0},{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 68",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 69",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 70",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 71",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 72",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 73",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 74",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 75",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 76",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 77",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 78",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 79",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 80",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 81",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 82",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 83",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 84",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 85",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 86",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 87",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 88",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 89",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 90",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 91",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 92",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 93",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},{"$f":"I102","v":""},{"$f":"J102","v":{"v":0,"d":"0.0000"}}]
["WP 94",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 95",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 96",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 97",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 98",{"$nulls":7},"",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["WP 99",{"$nulls":7},{"$f":"IF(C108=\"\",\"\",IF(AD108<AC108,360-AJ108,AJ108))","v":""},{"$f":"IF(C108=\"\",0,+AL108)","v":{"v":0,"d":"0.0"}},{"$f":"+K107-J107","v":{"v":-2.8030910925735952E-12,"d":"-0.0"}},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,1,1,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
[" ",null," "," "," ",{"$nulls":4},{"$f":"SUM(J10:J108)","v":{"v":16016.103436472162,"d":"16016.1"}},null," ",{"$nulls":15}," "," "," "," "," "," ",null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," ",null," "," "]

{"sheet":"Arrival Port Info","index":10,"n_rows":31,"n_cols":4,"rows_kept":31,"merged":[[1,3,1,4],[2,0,2,4],[9,0,9,4],[17,0,17,4],[27,1,27,4],[29,0,29,4],[31,0,31,4]]}
[]
[]
["PORT OF ARRIVAL INFORMATION"]
["Passage Plan Name on ECDIS"]
["User Chart Name on ECDIS"]
["Name of Arrival Berth"]
["VHF Channel(s) - Port Control"]
["VHF Channel(s) - VTS"]
["VHF Channel(s) - Pilots"]
["Tidal Information"]
["Standard Port"]
["Date"]
[null,"TIME ","HEIGHT"]
["High Water",null,null,"Mtrs"]
["Low Water",null,null,{"$f":"$D$14","v":"Mtrs"}]
["High Water",null,null,{"$f":"$D$14","v":"Mtrs"}]
["Low Water",null,null,{"$f":"$D$14","v":"Mtrs"}]
["Estimated Draft on Arrival"]
["Forward",null,"Mtrs"]
["Aft",null,"Mtrs"]
["Mean",null,"Mtrs"]
["Vessel’s Maximum Air-draft",null,"Mtrs"]
["Distance - Berth to Pilot Station",null,"NM"]
["Estimated Time to Pilot Station",null,"Hours"]
["Is There a Change of Pilots?"]
["If Yes, Where"]
["Number of Tugs"]
["Location Tugs will approach Vessel"]
["Remarks: (General route, channel to use, special precaution, etc)"]
[]
["Prevailing Current / Weather Information "]

{"sheet":"Arrival Port Safet Setting","index":11,"n_rows":31,"n_cols":8,"rows_kept":31,"merged":[[0,0,0,4],[1,3,1,4],[16,0,16,4],[17,0,17,4],[18,0,18,4],[19,0,19,4],[20,0,20,4],[21,0,21,4],[22,0,22,4],[23,0,23,4],[24,0,24,4],[26,1,26,3],[27,1,27,3],[28,1,29,3],[30,1,30,3]]}
["Safety Setting Arrival Port"]
["Beam:",32,"Cb:",0.7786]
["AREA","Ocean Passage (Open)","Fairways outside ports (Coastal / Shallow waters)","Fairways inside ports (Within Port Limits / Restricted Waters)","Remarks"]
["MAX. SPEED",{"v":12.5,"d":"12.50"},{"v":12.5,"d":"12.50"},{"v":6,"d":"6.00"}]
["DEEPEST DRAFT",{"v":10,"d":"10.00"},{"v":4.9,"d":"4.90"},{"v":19.8,"d":"19.80"},"Static Draft"]
["TOTAL CALCULATED SQUAT",{"v":2,"d":"2.00"},1.16,0.56]
["SAFETY MARGIN",{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},1.42,"Ensure it is equal to A3 in NAV 02 (Catzoc Consideration Tab)."]
["MINIMUM UKC REQUIRED",{"$f":"(B5+B6+B7)/2","v":{"v":7,"d":"7.00"}},{"$f":"(C5+C6+C7)*0.15","v":{"v":1.209,"d":"1.21"}},{"$f":"IF(F8>G8,F8,G8)","v":{"v":0.6,"d":"0.60"}},null,{"$f":"B2*0.015","v":0.48},0.6]
["TIDE",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["SAFETY DEPTH",{"$f":"IF((B5+B6+B8+B7-B9)<B5,ROUNDUP(B5,0),ROUNDUP((B5+B6+B8+B7-B9),0))","v":{"v":21,"d":"21.00"}},{"$f":"IF((C5+C6+C8+C7-C9)<C5,ROUNDUP(C5,0),ROUNDUP((C5+C6+C8+C7-C9),0))","v":{"v":10,"d":"10.00"}},{"$f":"IF((D5+D6+D8+D7-D9)<D5,ROUNDUP(D5,0),ROUNDUP((D5+D6+D8+D7-D9),0))","v":{"v":23,"d":"23.00"}}]
["SAFETY CONTOUR",{"$f":"B10","v":{"v":21,"d":"21.00"}},{"$f":"C10","v":{"v":10,"d":"10.00"}},{"$f":"D10","v":{"v":23,"d":"23.00"}}]
["SHALLOW CONTOUR",{"$f":"IF(ROUNDUP((B5+1),0)>=B11,B5,ROUNDUP((B5+1),0))","v":{"v":11,"d":"11.00"}},{"$f":"IF(ROUNDUP((C5+1),0)>=C11,C5,ROUNDUP((C5+1),0))","v":{"v":6,"d":"6.00"}},{"v":21,"d":"21.00"}]
["DEEP CONTOUR",{"$f":"ROUNDUP((F13*2),0)","v":{"v":24,"d":"24.00"}},{"$f":"ROUNDUP((G13*2),0)","v":{"v":13,"d":"13.00"}},{"$f":"ROUNDUP((H13*2),0)","v":{"v":41,"d":"41.00"}},null,{"$f":"B5+B6","v":{"v":12,"d":"12.00"}},{"$f":"C5+C6","v":{"v":6.0600000000000005,"d":"6.06"}},{"$f":"D5+D6","v":20.36}]
["Look Ahead Settings",{"$nulls":3},"FOM 3.29 Section 5.6"]
["Cross Track Distance",{"$nulls":3},"FOM 3.29 Section 5.8"]
[]
["SHALLOW CONTOUR = Next contour shallower than safety contour/must not be less than vessel’s draft"]
["SAFETY DEPTH = Vessel Draft + Dynamic Squat + UKC + Safety Margin - Height of Tide"]
["SAFETY CONTOUR = Safety contour should be set at a value equal to the safety depth"]
["DEPTH CONTOUR = Twice the Dynamic Draft (Max. Static draft + Squat)"]
["ECHO SOUNDER = Ensure alarm, if fitted, is used for safe navigation. "]
["NOTE (when marking NO GO AREA on ECDIS):"]
[]
["Shallow Contour should not be confused by the wording 'contour'. The safe/unsafe contour for Navigation is the safety contour. A shallow contour is only for additional indication of the underwater topography of the already 'un-safe' water; it is not calculation between draft and tide values. Reminding once again that the safety of the navigation is only to be dependent upon the 'Safety Contour' & 'Safety Depth' mentioned above."]
["All ECDIS parameters set prior to the beginning of the voyage must not be removed/changed/de-activated without permission from the Master. Any safety parameters to be re-set to original settings after planning/trial/simulation mode"]
[]
["Prepared by :"]
[null,"Second Officer"]
[]
["Calculation confirmed by :"]
[null,"Master"]

{"sheet":"Pilot to Berth","index":12,"n_rows":40,"n_cols":87,"rows_kept":40,"merged":[[2,1,2,2],[3,7,3,9],[4,1,4,2],[4,6,4,9],[4,12,4,14],[5,7,5,12],[6,0,8,0],[6,1,8,1],[6,2,7,4],[6,5,7,7],[6,8,8,8],[6,9,8,9],[6,10,8,10],[6,11,8,11],[6,12,7,15],[6,16,8,16],[6,17,8,17],[6,18,8,18],[6,19,8,19],[6,20,7,20],[6,21,8,21],[6,22,8,22],[6,23,7,24],[39,5,39,7]]}
[]
[]
[null,"All dates & times are GMT",{"$nulls":9},{"$f":"+'Vsl Details'!C7","v":"M/T Example"}]
[null,"PILOTS",null,"SPD"," ","Voy :",{"$f":"+'Vsl Details'!C9","v":11},{"$f":"+'Vsl Details'!C10","v":"Loaded"},null,null,"Time",{"$nulls":34},"Yes"]
[null,"2005-07-22T12:00:00",null,14.3," ","From :",{"$f":"'Checklist A'!$G$8","v":"Singapore"},{"$nulls":3},{"$f":"+'Vsl Details'!C14","v":{"v":8,"d":" 8"}},"To :",{"$f":"'Checklist A'!$G$9","v":"Rotterdam"},null,null,{"$f":"+'Vsl Details'!C18","v":{"v":1,"d":" 1"}},{"$nulls":6},"Pilot to Berth",{"$nulls":22},"No"]
[{"$nulls":3}," "," "," ",{"$nulls":39},"Level 1"]
["WP No.","GEOGRAPHICAL AREA WAYPOINT","LATITUDE",null,null,"LONGITUDE",null,null,"CO","DIST. TO NEXT WP","DTG","RL/GC","Verification Freq / Method",{"$nulls":3},"Max Spd (kts)","T&P Notices","Safety Setting","UKC","MARPOL Special area / ECA Zone","Security Level","Remarks: NAV Aids, Restrictions, Weather, Cautions, Traffic Density, UKC, Tides etc, T&P notice number effecting each leg, extra lookout if passing through HRA, Area where vessel should be hardened.","Watch Level",{"$nulls":21},"Level 2"]
[{"$nulls":26},"latrad","longrad","dlon_W","dlon_E","dphi","q1","q","dlon_min","tc_rad","tc","dist_rad","dist",{"$nulls":7},"Level 3"]
[null,null,"DEG","MIN","N/S","DEG","MIN","E/W",{"$nulls":4},"Freq","Main","Alt 1","Alt 2",{"$nulls":4},"Yes / No",null,null,"Bridge","E/R",{"$nulls":20},"Ocean Passage (Open)","Fairways outside ports (Coastal / Shallow waters)","Fairways inside ports (Within Port Limits / Restricted Waters)",{"$nulls":37},"Course","Distance"]
["PB 1","PILOT STATION",{"v":27,"d":"27°"},{"v":0,"d":"00.00`"},"S",{"v":160,"d":"160°"},{"v":9,"d":"09.00`"},"E",{"$f":"IF(C11=\"\",\"\",IF(AD10<AC10,360-AJ10,AJ10))","v":{"v":27.7622246258402,"d":"028°"}},{"$f":"IF(C11=\"\",0,+AL10)","v":{"v":3674.4751808764377,"d":"3674.5"}},{"$f":"+J40","v":{"v":16016.103436472162,"d":"16016.1"}},null,"< 1 h","Vis","Rdr","Gps",null,"Yes","Ocean Passage (Open)",null,"No","Level 1",{"$nulls":4},{"$f":"IF(E10=\"N\",RADIANS(C10+(D10/60)),-RADIANS(C10+(D10/60)))","v":-0.47123889803846897},{"$f":"IF(H10=\"E\",+RADIANS(F10+(G10/60)),-RADIANS(F10+(G10/60)))","v":2.795144797068919},{"$f":"MOD(AB11-AB10,2*PI())","v":0.517548300858051},{"$f":"MOD(AB10-AB11,2*PI())","v":5.765637006321535},{"$f":"LN(TAN(AA11/2+PI()/4)/TAN(AA10/2+PI()/4))","v":0.9831883810571177},{"$f":"COS(AA10)","v":0.8910065241883679},{"$f":"IF(AA11=AA10,AF10,(AA11-AA10)/AE10)","v":0.9619957158765963},{"$f":"MIN(AC10,AD10)","v":0.517548300858051},{"$f":"MOD(ATAN2(AE10,AH10),2*PI())","v":0.4845422273991623},{"$f":"DEGREES(AI10)","v":{"v":27.7622246258402,"d":"27.8"}},{"$f":"SQRT(AG10^2*AH10^2+(AA11-AA10)^2)","v":1.0688615031518003},{"$f":"DEGREES(AK10)*60","v":{"v":3674.4751808764377,"d":"3674.5"}},{"$nulls":47},{"$f":"I10","v":{"v":27.7622246258402,"d":"27.76222"}},{"$f":"J10","v":{"v":3674.4751808764377,"d":"3674.4752"}}]
["PB 2","GHAR BUOY",{"v":27,"d":"27°"},{"v":11.5,"d":"11.50`"},"N",{"v":170,"d":"170°"},{"v":11.8,"d":"11.80`"},"W",{"v":269.9992267849206,"d":"270°"},{"v":7410.070113943125,"d":"7410.1"},{"$f":"+K10-J10","v":{"v":12341.628255595724,"d":"12341.6"}},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},{"$f":"IF(E11=\"N\",RADIANS(C11+(D11/60)),-RADIANS(C11+(D11/60)))","v":0.47458411243812476},{"$f":"IF(H11=\"E\",+RADIANS(F11+(G11/60)),-RADIANS(F11+(G11/60)))","v":-2.970492209252616},{"$f":"MOD(AB12-AB11,2*PI())","v":3.8598829072480596},{"$f":"MOD(AB11-AB12,2*PI())","v":2.4233023999315266},{"$f":"LN(TAN(AA12/2+PI()/4)/TAN(AA11/2+PI()/4))","v":-3.2702826867868676E-5},{"$f":"COS(AA11)","v":0.8894828460823052},{"$f":"IF(AA12=AA11,AF11,(AA12-AA11)/AE11)","v":0.889489492271762},{"$f":"MIN(AC11,AD11)","v":2.4233023999315266},{"$f":"MOD(ATAN2(AE11,AH11),2*PI())","v":1.570809821943858},{"$f":"DEGREES(AI11)","v":{"v":90.00077321507939,"d":"90.0"}},{"$f":"SQRT(AG11^2*AH11^2+(AA12-AA11)^2)","v":2.155502021532315},{"$f":"DEGREES(AK11)*60","v":{"v":7410.070113943125,"d":"7410.1"}},{"$nulls":47},{"v":269.9992267849206,"d":"269.99923"},{"v":7410.070113943125,"d":"7410.0701"}]
["PB 3","RAS TANNURAH RACON (K)",{"v":27,"d":"27°"},{"v":11.4,"d":"11.40`"},"N",{"v":50,"d":"050°"},{"v":57.5,"d":"57.50`"},"E",{"v":98.89184782811951,"d":"099°"},{"v":60.81394329207227,"d":"60.8"},{"$f":"+K11-J11","v":{"v":4931.558141652599,"d":"4931.6"}},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},{"$f":"IF(E12=\"N\",RADIANS(C12+(D12/60)),-RADIANS(C12+(D12/60)))","v":0.4745550236172582},{"$f":"IF(H12=\"E\",+RADIANS(F12+(G12/60)),-RADIANS(F12+(G12/60)))","v":0.8893906979954438},0.019634954084936207,6.26355035309465,-3.0718896058628425E-3,0.8894961383826187,0.89011960463655,0.019634954084936207,1.7259883479818887,{"v":98.89184782811951,"d":"98.9"},0.017690059026129676,{"v":60.81394329207227,"d":"60.8"},{"$nulls":47},{"v":98.89184782811951,"d":"98.89185"},{"v":60.81394329207227,"d":"60.8139"}]
["PB 4","FIELD",{"v":27,"d":"27°"},{"v":2,"d":"02.00`"},"N",{"v":52,"d":"052°"},{"v":5,"d":"05.00`"},"E",{"v":131.88581763263926,"d":"132°"},{"v":29.955891612915163,"d":"30.0"},{"v":4870.744198360527,"d":"4870.7"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.47182067445580045,0.90902565208038,0.007272205216643068,6.275913101962943,-0.006521728036198491,0.8907422524501034,0.8920586907370712,0.007272205216643068,2.3018417543743483,{"v":131.88581763263926,"d":"131.9"},0.008713815650265406,{"v":29.955891612915163,"d":"30.0"},{"$nulls":47},{"v":131.88581763263926,"d":"131.88582"},{"v":29.955891612915163,"d":"29.9559"}]
["PB 5","CABLE BANK",{"v":26,"d":"26°"},{"v":42,"d":"42.00`"},"N",{"v":52,"d":"052°"},{"v":30,"d":"30.00`"},"E",{"v":106.49874610577218,"d":"106°"},{"v":104.5795411838232,"d":"104.6"},{"v":4840.788306747611,"d":"4840.8"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.46600291028248597,0.9162978572970231,0.03257947937056083,6.250605827809025,-0.009649705905783667,0.8933713883278376,0.8952998030949143,0.03257947937056083,1.858753768791214,{"v":106.49874610577218,"d":"106.5"},0.030420955398045384,{"v":104.5795411838232,"d":"104.6"},{"$nulls":47},{"v":106.49874610577218,"d":"106.49875"},{"v":104.5795411838232,"d":"104.5795"}]
["PB 6","FORUR ISLAND",{"v":26,"d":"26°"},{"v":12.3,"d":"12.30`"},"N",{"v":54,"d":"054°"},{"v":22,"d":"22.00`"},"E",{"v":96.64091344577552,"d":"097°"},{"v":50.15285243581551,"d":"50.2"},{"v":4736.208765563788,"d":"4736.2"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.457363530485114,0.9488773366675839,0.016144295580947432,6.267041011598639,-1.8796422586359032E-3,0.8972198376038806,0.897591870213388,0.016144295580947432,1.6867021317636413,{"v":96.64091344577552,"d":"96.6"},0.014588873404530646,{"v":50.15285243581551,"d":"50.2"},{"$nulls":47},{"v":96.64091344577552,"d":"96.64091"},{"v":50.15285243581551,"d":"50.1529"}]
["PB 7","TONBE ISLAND",{"v":26,"d":"26°"},{"v":6.5,"d":"06.50`"},"N",{"v":55,"d":"055°"},{"v":17.5,"d":"17.50`"},"E",{"v":70.38069863120359,"d":"070°"},{"v":11.912955468934165,"d":"11.9"},{"v":4686.055913127972,"d":"4686.1"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.4556763788748529,0.9650216322485313,3.6361026083215897E-3,6.279549204571264,1.2961382792950143E-3,0.8979635797038885,0.8977073304985035,3.6361026083215897E-3,1.228374920968369,{"v":70.38069863120359,"d":"70.4"},0.003465338276272771,{"v":11.912955468934165,"d":"11.9"},{"$nulls":47},{"v":70.38069863120359,"d":"70.38070"},{"v":11.912955468934165,"d":"11.9130"}]
["PB 8","TSS OUT",{"v":26,"d":"26°"},{"v":10.5,"d":"10.50`"},"N",{"v":55,"d":"055°"},{"v":30,"d":"30.00`"},"E",{"v":66.65374013681041,"d":"067°"},{"v":51.73019652138883,"d":"51.7"},{"v":4674.142957659038,"d":"4674.1"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.45683993170951576,0.9686577348568529,0.015417075059283247,6.267768232120303,0.006654402881355833,0.8974509275255026,0.8961297330456026,0.015417075059283247,1.1633272241560373,{"v":66.65374013681041,"d":"66.7"},0.015047704200032538,{"v":51.73019652138883,"d":"51.7"},{"$nulls":47},{"v":66.65374013681041,"d":"66.65374"},{"v":51.73019652138883,"d":"51.7302"}]
["PB 9","TSS HORMUZ 1",{"v":26,"d":"26°"},{"v":31,"d":"31.00`"},"N",{"v":56,"d":"056°"},{"v":23,"d":"23.00`"},"E",{"v":65.17850251325903,"d":"065°"},{"v":5.717108158419505,"d":"5.7"},{"v":4622.412761137649,"d":"4622.4"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.46280313998716305,0.9840748099161362,1.6871516102611173E-3,6.2814981555693254,7.8034179774028913E-4,0.8948045300584291,0.8946486050335065,1.6871516102611173E-3,1.1375794703757691,{"v":65.17850251325903,"d":"65.2"},1.6630393509508323E-3,{"v":5.717108158419505,"d":"5.7"},{"$nulls":47},{"v":65.17850251325903,"d":"65.17850"},{"v":5.717108158419505,"d":"5.7171"}]
["PB 10","TSS HORMUZ 2",{"v":26,"d":"26°"},{"v":33.4,"d":"33.40`"},"N",{"v":56,"d":"056°"},{"v":28.8,"d":"28.80`"},"E",{"v":90,"d":"090°"},{"v":3.5779705018346784,"d":"3.6"},{"v":4616.69565297923,"d":"4616.7"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.46350127168796074,0.9857619615263973,1.163552834662962E-3,6.282021754344923,0,0.8944926254586114,0.8944926254586114,1.163552834662962E-3,1.5707963267948966,{"v":90,"d":"90.0"},1.0407894299374826E-3,{"v":3.5779705018346784,"d":"3.6"},{"$nulls":47},{"v":90,"d":"90.00000"},{"v":3.5779705018346784,"d":"3.5780"}]
["PB 11","TSS HORMUZ 3",{"v":26,"d":"26°"},{"v":33.4,"d":"33.40`"},"N",{"v":56,"d":"056°"},{"v":32.8,"d":"32.80`"},"E",{"v":149.3791183222242,"d":"149°"},{"v":62.05287305205036,"d":"62.1"},{"v":4613.117682477395,"d":"4613.1"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.46350127168796074,0.9869255143610602,0.010239264945033355,6.272946042234553,-0.01729925893452955,0.8944926254586114,0.8979246106169625,0.010239264945033355,2.607157448449,{"v":149.3791183222242,"d":"149.4"},0.01805044908467236,{"v":62.05287305205036,"d":"62.1"},{"$nulls":47},{"v":149.3791183222242,"d":"149.37912"},{"v":62.05287305205036,"d":"62.0529"}]
["PB 12","RAS AL KUH 1",{"v":25,"d":"25°"},{"v":40,"d":"40.00`"},"N",{"v":57,"d":"057°"},{"v":8,"d":"08.00`"},"E",{"v":140.00938056519738,"d":"140°"},{"v":13.052279960938492,"d":"13.1"},{"v":4551.064809425345,"d":"4551.1"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.4479678413452113,0.9971647793060936,2.7052603405912645E-3,6.280480046838995,-0.00322507590361609,0.9013291614454622,0.9019577131179077,2.7052603405912645E-3,2.4436246745404535,{"v":140.00938056519738,"d":"140.0"},3.7967543368408923E-3,{"v":13.052279960938492,"d":"13.1"},{"$nulls":47},{"v":140.00938056519738,"d":"140.00938"},{"v":13.052279960938492,"d":"13.0523"}]
["PB 13","RAS AL KUH 2",{"v":25,"d":"25°"},{"v":30,"d":"30.00`"},"N",{"v":57,"d":"057°"},{"v":17.3,"d":"17.30`"},"E",{"v":136.30273186512736,"d":"136°"},{"v":124.48131292684803,"d":"124.5"},{"v":4538.012529464406,"d":"4538.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.44505895925855404,0.9998700396466849,0.02754711336064375,6.2556381938189425,-0.02882915937034003,0.9025852843498606,0.9081062143924088,0.02754711336064375,2.378931450509464,{"v":136.30273186512736,"d":"136.3"},0.03621014612964796,{"v":124.48131292684803,"d":"124.5"},{"$nulls":47},{"v":136.30273186512736,"d":"136.30273"},{"v":124.48131292684803,"d":"124.4813"}]
["PB 14","24° NORTH",{"v":24,"d":"24°"},{"v":0,"d":"00.00`"},"N",{"v":58,"d":"058°"},{"v":52,"d":"52.00`"},"E",{"v":136.39000837687638,"d":"136°"},{"v":110.48936444860492,"d":"110.5"},{"v":4413.531216537558,"d":"4413.5"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.4188790204786391,1.0274171530073286,0.024143721319255018,6.259041585860331,-0.025344553488278247,0.9135454576426009,0.9181876770494501,0.024143721319255018,2.38045471299914,{"v":136.39000837687638,"d":"136.4"},0.03214005330106875,{"v":110.48936444860492,"d":"110.5"},{"$nulls":47},{"v":136.39000837687638,"d":"136.39001"},{"v":110.48936444860492,"d":"110.4894"}]
["PB 15","RAS AL HADD",{"v":22,"d":"22°"},{"v":40,"d":"40.00`"},"N",{"v":60,"d":"060°"},{"v":15,"d":"15.00`"},"E",{"v":180,"d":"180°"},{"v":40.00000000000012,"d":"40.0"},{"v":4303.041852088953,"d":"4303.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.3956079637853814,1.0515608743265836,0,0,-0.012579196741493666,0.9227624443554423,0.9249818240180641,0,3.141592653589793,{"v":180,"d":"180.0"},0.011635528346628898,{"v":40.00000000000012,"d":"40.0"},{"$nulls":47},{"v":180,"d":"180.00000"},{"v":40.00000000000012,"d":"40.0000"}]
["PB 16","RAS QUMAYLAH",{"v":22,"d":"22°"},{"v":0,"d":"00.00`"},"N",{"v":60,"d":"060°"},{"v":15,"d":"15.00`"},"E",{"v":204.09544375790784,"d":"204°"},{"v":618.9293944162871,"d":"618.9"},{"v":4263.041852088953,"d":"4263.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.3839724354387525,1.0515608743265836,6.20609993188317,0.07708537529641624,-0.17236328619713176,0.9271838545667874,0.9535199839956845,0.07708537529641624,2.721047825285186,{"v":155.90455624209216,"d":"155.9"},0.1800392628323136,{"v":618.9293944162871,"d":"618.9"},{"$nulls":47},{"v":204.09544375790784,"d":"204.09544"},{"v":618.9293944162871,"d":"618.9294"}]
["PB 17","SUQUTRA",{"v":12,"d":"12°"},{"v":35,"d":"35.00`"},"N",{"v":55,"d":"055°"},{"v":50,"d":"50.00`"},"E",{"v":208.69878397038536,"d":"209°"},{"v":1647.368785180876,"d":"1647.4"},{"v":3644.112457672666,"d":"3644.1"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0.2196205975426198,0.9744754990301674,6.051347404873006,0.2318379023065802,-0.4234819293166806,0.9759801759455132,0.9925652841910086,0.2318379023065802,2.6407043819879976,{"v":151.30121602961464,"d":"151.3"},0.4792001549330909,{"v":1647.368785180876,"d":"1647.4"},{"$nulls":47},{"v":208.69878397038536,"d":"208.69878"},{"v":1647.368785180876,"d":"1647.3688"}]
["PB 18","COMORES",{"v":11,"d":"11°"},{"v":30,"d":"30.00`"},"S",{"v":42,"d":"042°"},{"v":33,"d":"33.00`"},"E",{"v":198.49390683680642,"d":"198°"},{"v":284.70279427502004,"d":"284.7"},{"v":1996.74367249179,"d":"1996.7"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.2007128639793479,0.7426375967235872,6.256132703773674,0.02705260340591209,-0.0808802924367075,0.9799247046208296,0.9710624674262374,0.02705260340591209,2.8188130877304314,{"v":161.50609316319358,"d":"161.5"},0.08281668582878603,{"v":284.70279427502004,"d":"284.7"},{"$nulls":47},{"v":198.49390683680642,"d":"198.49391"},{"v":284.70279427502004,"d":"284.7028"}]
["PB 19","MOZAMBIQUE",{"v":16,"d":"16°"},{"v":0,"d":"00.00`"},"S",{"v":41,"d":"041°"},{"v":0,"d":"00.00`"},"E",{"v":208.07751478741096,"d":"208°"},{"v":606.3617142253464,"d":"606.4"},{"v":1712.04087821677,"d":"1712.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.2792526803190927,0.7155849933176751,6.194464403536541,0.08872090364304508,-0.16631654377543895,0.9612616959383189,0.935716845140112,0.08872090364304508,2.651547574772076,{"v":151.92248521258904,"d":"151.9"},0.17638347285448722,{"v":606.3617142253464,"d":"606.4"},{"$nulls":47},{"v":208.07751478741096,"d":"208.07751"},{"v":606.3617142253464,"d":"606.3617"}]
["PB 20","PUNTA ZAVORA",{"v":24,"d":"24°"},{"v":55,"d":"55.00`"},"S",{"v":35,"d":"035°"},{"v":55,"d":"55.00`"},"E",{"v":216.38757082097197,"d":"216°"},{"v":285.70629699954657,"d":"285.7"},{"v":1105.6791639914236,"d":"1105.7"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.4348778719552538,0.62686408967463,6.227916547533099,0.05526875964648714,-0.07499877879860467,0.9069215015644624,0.8920716985642526,0.05526875964648714,2.506509735961216,{"v":143.61242917902803,"d":"143.6"},0.08310859293871473,{"v":285.70629699954657,"d":"285.7"},{"$nulls":47},{"v":216.38757082097197,"d":"216.38757"},{"v":285.70629699954657,"d":"285.7063"}]
["PB 21","CAPE SANTA LUCIA",{"v":28,"d":"28°"},{"v":45,"d":"45.00`"},"S",{"v":32,"d":"032°"},{"v":45,"d":"45.00`"},"E",{"v":216.26875208786186,"d":"216°"},{"v":159.25560973058813,"d":"159.3"},{"v":819.972866991877,"d":"820.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.5017821599483697,0.5715953300281429,6.251594847718489,0.03159045946109729,-0.043054393507114576,0.8767267557075077,0.8675083528120471,0.03159045946109729,2.5085835140670363,{"v":143.73124791213814,"d":"143.7"},0.04632557903449804,{"v":159.25560973058813,"d":"159.3"},{"$nulls":47},{"v":216.26875208786186,"d":"216.26875"},{"v":159.25560973058813,"d":"159.2556"}]
["PB 22","SOUTH OF DURBAN",{"v":30,"d":"30°"},{"v":53.4,"d":"53.40`"},"S",{"v":30,"d":"030°"},{"v":56.4,"d":"56.40`"},"E",{"v":220.19148377714805,"d":"220°"},{"v":208.9300695183834,"d":"208.9"},{"v":660.7172572612889,"d":"660.7"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.5391322059410484,0.5400048705670456,6.23681772671827,0.04636758046131606,-0.054885167381075385,0.858154522511046,0.8458707574071632,0.04636758046131606,2.4401189304166726,{"v":139.80851622285195,"d":"139.8"},0.060775293658607225,{"v":208.9300695183834,"d":"208.9"},{"$nulls":47},{"v":220.19148377714805,"d":"220.19148"},{"v":208.9300695183834,"d":"208.9301"}]
["PB 23","EAST LONDON",{"v":33,"d":"33°"},{"v":33,"d":"33.00`"},"S",{"v":28,"d":"028°"},{"v":17,"d":"17.00`"},"E",{"v":241.18812586085238,"d":"241°"},{"v":87.14863268556118,"d":"87.1"},{"v":451.7871877429055,"d":"451.8"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.5855579640440975,0.49363729010572954,6.256423591982339,0.026761715197246405,-0.014719600647821247,0.8334038487252763,0.8300024610904573,0.026761715197246405,2.0736583941932296,{"v":118.81187413914763,"d":"118.8"},0.02535050964956985,{"v":87.14863268556118,"d":"87.1"},{"$nulls":47},{"v":241.18812586085238,"d":"241.18813"},{"v":87.14863268556118,"d":"87.1486"}]
["PB 24","WEST OF CAPE RECIFE",{"v":34,"d":"34°"},{"v":15,"d":"15.00`"},"S",{"v":26,"d":"026°"},{"v":45,"d":"45.00`"},"E",{"v":256.8308460526402,"d":"257°"},{"v":96.56462732512952,"d":"96.6"},{"v":364.6385550573443,"d":"364.6"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.5977752688080579,0.46687557490848314,6.250024051391694,0.033161255787892197,-0.007759069702215483,0.8265897491271886,0.8247819437449513,0.033161255787892197,1.8006414228783334,{"v":103.16915394735982,"d":"103.2"},0.028089511463079916,{"v":96.56462732512952,"d":"96.6"},{"$nulls":47},{"v":256.8308460526402,"d":"256.83085"},{"v":96.56462732512952,"d":"96.5646"}]
["PB 25","CAPE ST. FRANCIS",{"v":34,"d":"34°"},{"v":37,"d":"37.00`"},"S",{"v":24,"d":"024°"},{"v":51,"d":"51.00`"},"E",{"v":266.3136152805932,"d":"266°"},{"v":124.42614221317564,"d":"124.4"},{"v":268.07392773221477,"d":"268.1"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.6041748093987037,0.43371431912059094,6.239261187671062,0.04392411950852404,-2.8299641509531314E-3,0.8229711546617382,0.8223092396919742,0.04392411950852404,1.6351358776437526,{"v":93.6863847194068,"d":"93.7"},0.03619409761957699,{"v":124.42614221317564,"d":"124.4"},{"$nulls":47},{"v":266.3136152805932,"d":"266.31362"},{"v":124.42614221317564,"d":"124.4261"}]
["PB 26","TSS IN",{"v":34,"d":"34°"},{"v":45,"d":"45.00`"},"S",{"v":22,"d":"022°"},{"v":20,"d":"20.00`"},"E",{"v":261.6093311359798,"d":"262°"},{"v":78.80927292794783,"d":"78.8"},{"v":143.64778551903913,"d":"143.6"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.6065019150680295,0.3897901996120669,6.255550927356342,0.027634379823243516,-0.004076091648164332,0.8216469379421637,0.82069165475275,0.027634379823243516,1.717241124916621,{"v":98.39066886402018,"d":"98.4"},0.022924688228258692,{"v":78.80927292794783,"d":"78.8"},{"$nulls":47},{"v":261.6093311359798,"d":"261.60933"},{"v":78.80927292794783,"d":"78.8093"}]
["PB 27","TSS OUT",{"v":34,"d":"34°"},{"v":56.5,"d":"56.50`"},"S",{"v":20,"d":"020°"},{"v":45,"d":"45.00`"},"E",{"v":245.38441649982087,"d":"245°"},{"v":36.01197839268674,"d":"36.0"},{"v":64.8385125910913,"d":"64.8"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.6098471294676854,0.3621558197888234,6.2715497788329575,0.011635528346628898,-0.005330989305595397,0.8197355828213687,0.8184828143260461,0.011635528346628898,2.0004193061726125,{"v":114.61558350017913,"d":"114.6"},0.010475459885157318,{"v":36.01197839268674,"d":"36.0"},{"$nulls":47},{"v":245.38441649982087,"d":"245.38442"},{"v":36.01197839268674,"d":"36.0120"}]
["PB 28","CAPE AGULHAS",{"v":35,"d":"35°"},{"v":11.5,"d":"11.50`"},"S",{"v":20,"d":"020°"},{"v":5,"d":"05.00`"},"E",{"v":276.9738260454326,"d":"277°"},{"v":28.826534198407362,"d":"28.8"},{"v":28.82653419840456,"d":"28.8"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.6142104525976712,0.3505202914421945,6.273004219876286,0.010181087303300251,1.2453595392335512E-3,0.8172287283738303,0.8175219270064169,0.010181087303300251,1.4490801008407628,{"v":83.02617395456744,"d":"83.0"},0.00838529889501588,{"v":28.826534198407362,"d":"28.8"},{"$nulls":47},{"v":276.9738260454326,"d":"276.97383"},{"v":28.826534198407362,"d":"28.8265"}]
["PB 29","QUOIN POINT",{"v":35,"d":"35°"},{"v":8,"d":"08.00`"},"S",{"v":19,"d":"019°"},{"v":30,"d":"30.00`"},"E","",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},-0.6131923438673411,0.34033920413889424,5.942846103040692,0.34033920413889424,0.6556797708118176,0.8178150544913865,0.9352009489451361,0.34033920413889424,0.47878156061731747,{"v":27.43216273205928,"d":"27.4"},0.6908766458630974,{"v":2375.0589583265933,"d":"2375.1"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["PB 30",{"$nulls":7},{"$f":"IF(C39=\"\",\"\",IF(AD39<AC39,360-AJ39,AJ39))","v":""},{"$f":"IF(C39=\"\",0,+AL39)","v":{"v":0,"d":"0.0"}},{"$f":"+K38-J38","v":{"v":-2.8030910925735952E-12,"d":"-0.0"}},null,"< 1 h","Vis","Rdr","Gps",{"$nulls":10},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
[" ",null," "," "," ","TOTAL DISTANCE:",{"$nulls":3},{"$f":"SUM(J10:J39)","v":{"v":16016.103436472162,"d":"16016.1"}},null," "]

{"sheet":"Implementation","index":13,"n_rows":51,"n_cols":13,"rows_kept":51,"merged":[[2,3,4,4],[2,5,2,7],[2,8,2,9],[3,5,3,7],[3,8,3,9],[4,5,4,7],[4,8,4,9],[7,0,7,12]]}
[]
[]
[{"$nulls":3},"NAV-01",{"$nulls":4},"Doc No :  NAV-01"]
[{"$nulls":5},"PASSAGE PLAN",null,null,"Revision: 01                                                              \nDate: 15 Oct 2024"]
[{"$nulls":8},"Issued by: DPA\nApproved by: MD"]
[]
[]
["To be filled by the Duty Officer in whose watch the next Voyage Chart is to be used"]
["CHARTS ","CHARTS","Chart Corrected upto ","NO-GO Areas                 ( As per BTM Practical Guide Diag 1)","Margins Of Safety                          ( As per BTM Practical Guide Diag 2)","Chart Change                                       (Clearly Marked)","Under Keel Clearance                                     ( Is Filled TSM 002 - available if applicable)","Wheel-Over Position                                ( As per BTM Practical Guide Diag 4 WOP)","Parallel Index                               ( As per BTM Practical Guide Diag 5 )","Abort Position / Contigency Plan advocated","Position Fixing Method & Interval","T&P\nNotices","Duty Officer's Initials"]
[{"$f":"+'Checklist A'!J15","v":1111},{"$f":"IF(A10=0,\"\",A10)","v":1111},null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!K15","v":2222},{"$f":"IF(A11=0,\"\",A11)","v":2222},null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!M15","v":3333},3333,null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!N15","v":4444},4444,null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!O15","v":5555},5555,null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!P15","v":6666},6666,null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!J16","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!K16","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!M16","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!N16","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!O16","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!P16","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!J17","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!K17","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!M17","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!N17","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!O17","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!P17","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!J18","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!K18","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!M18","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!N18","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!O18","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!P18","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!J19","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!K19","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!M19","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!N19","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!O19","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!P19","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!J20","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!K20","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!M20","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!N20","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!O20","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!P20","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!J21","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!K21","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!M21","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!N21","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!O21","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]
[{"$f":"+'Checklist A'!P21","v":0},"",null,"[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]","[  ]"]

{"sheet":"Appendix Deviation","index":14,"n_rows":40,"n_cols":86,"rows_kept":40,"merged":[[2,1,2,2],[3,7,3,9],[4,1,4,2],[4,6,4,9],[4,12,4,14],[5,7,5,12],[6,0,8,0],[6,1,8,1],[6,2,7,4],[6,5,7,7],[6,8,8,8],[6,9,8,9],[6,10,8,10],[6,11,8,11],[6,12,7,15],[6,16,8,16],[6,17,8,17],[6,18,8,18],[6,19,8,19],[6,20,7,20],[6,21,8,21],[6,22,8,22],[6,23,8,23],[39,5,39,7]]}
[]
[]
[null,"All dates & times are GMT",{"$nulls":9},{"$f":"+'Vsl Details'!C7","v":"M/T Example"}]
[null,"PILOTS",null,"SPD"," ","Voy :",{"$f":"+'Vsl Details'!C9","v":11},{"$f":"+'Vsl Details'!C10","v":"Loaded"},null,null,"Time",{"$nulls":33},"Yes"]
[null,"2005-07-22T12:00:00",null,14.3," ","From :",{"$f":"'Checklist A'!$G$8","v":"Singapore"},{"$nulls":3},{"$f":"+'Vsl Details'!C14","v":{"v":8,"d":" 8"}},"To :",{"$f":"'Checklist A'!$G$9","v":"Rotterdam"},null,null,{"$f":"+'Vsl Details'!C18","v":{"v":1,"d":" 1"}},{"$nulls":6},"Appendix - Deviation",{"$nulls":21},"No"]
[{"$nulls":3}," "," "," ",{"$nulls":38},"Level 1"]
["WP No.","GEOGRAPHICAL AREA WAYPOINT","LATITUDE",null,null,"LONGITUDE",null,null,"CO","DIST. TO NEXT WP","DTG","RL/GC","Verification Freq / Method",{"$nulls":3},"Max Spd","T&P Notices","Safety Setting","UKC","MARPOL Special area / ECA Zone","Security Level","Remarks: NAV Aids, Restrictions, Weather, Cautions, Traffic Density, UKC, Tides etc, T&P notice number effecting each leg, extra lookout if passing through HRA, Area where vessel should be hardened.","Watch Level",{"$nulls":20},"Level 2"]
[{"$nulls":25},"latrad","longrad","dlon_W","dlon_E","dphi","q1","q","dlon_min","tc_rad","tc","dist_rad","dist",{"$nulls":7},"Level 3"]
[null,null,"DEG","MIN","N/S","DEG","MIN","E/W",{"$nulls":4},"Freq","Main","Alt 1","Alt 2",{"$nulls":4},"Yes / No",{"$nulls":23},"Ocean Passage (Open)","Fairways outside ports (Coastal / Shallow waters)","Fairways inside ports (Within Port Limits / Restricted Waters)",{"$nulls":37},"Course","Distance"]
["PB 1","PILOT STATION",{"v":27,"d":"27°"},{"v":0,"d":"00.00`"},"S",{"v":160,"d":"160°"},{"v":9,"d":"09.00`"},"E",{"$f":"IF(C11=\"\",\"\",IF(AC10<AB10,360-AI10,AI10))","v":{"v":27.7622246258402,"d":"028°"}},{"$f":"IF(C11=\"\",0,+AK10)","v":{"v":3674.4751808764377,"d":"3674.5"}},{"$f":"+J40","v":{"v":16016.103436472162,"d":"16016.1"}},null,"< 1 h","Vis","Rdr","Gps","MAN","Yes","Ocean Passage (Open)",null,"No","Level 1",{"$nulls":3},{"$f":"IF(E10=\"N\",RADIANS(C10+(D10/60)),-RADIANS(C10+(D10/60)))","v":-0.47123889803846897},{"$f":"IF(H10=\"E\",+RADIANS(F10+(G10/60)),-RADIANS(F10+(G10/60)))","v":2.795144797068919},{"$f":"MOD(AA11-AA10,2*PI())","v":0.517548300858051},{"$f":"MOD(AA10-AA11,2*PI())","v":5.765637006321535},{"$f":"LN(TAN(Z11/2+PI()/4)/TAN(Z10/2+PI()/4))","v":0.9831883810571177},{"$f":"COS(Z10)","v":0.8910065241883679},{"$f":"IF(Z11=Z10,AE10,(Z11-Z10)/AD10)","v":0.9619957158765963},{"$f":"MIN(AB10,AC10)","v":0.517548300858051},{"$f":"MOD(ATAN2(AD10,AG10),2*PI())","v":0.4845422273991623},{"$f":"DEGREES(AH10)","v":{"v":27.7622246258402,"d":"27.8"}},{"$f":"SQRT(AF10^2*AG10^2+(Z11-Z10)^2)","v":1.0688615031518003},{"$f":"DEGREES(AJ10)*60","v":{"v":3674.4751808764377,"d":"3674.5"}},{"$nulls":47},{"$f":"I10","v":{"v":27.7622246258402,"d":"27.76222"}},{"v":3674.4751808764377,"d":"3674.4752"}]
["PB 2","GHAR BUOY",{"v":27,"d":"27°"},{"v":11.5,"d":"11.50`"},"N",{"v":170,"d":"170°"},{"v":11.8,"d":"11.80`"},"W",{"v":269.9992267849206,"d":"270°"},{"v":7410.070113943125,"d":"7410.1"},{"$f":"+K10-J10","v":{"v":12341.628255595724,"d":"12341.6"}},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},{"$f":"IF(E11=\"N\",RADIANS(C11+(D11/60)),-RADIANS(C11+(D11/60)))","v":0.47458411243812476},{"$f":"IF(H11=\"E\",+RADIANS(F11+(G11/60)),-RADIANS(F11+(G11/60)))","v":-2.970492209252616},{"$f":"MOD(AA12-AA11,2*PI())","v":3.8598829072480596},{"$f":"MOD(AA11-AA12,2*PI())","v":2.4233023999315266},{"$f":"LN(TAN(Z12/2+PI()/4)/TAN(Z11/2+PI()/4))","v":-3.2702826867868676E-5},{"$f":"COS(Z11)","v":0.8894828460823052},{"$f":"IF(Z12=Z11,AE11,(Z12-Z11)/AD11)","v":0.889489492271762},{"$f":"MIN(AB11,AC11)","v":2.4233023999315266},{"$f":"MOD(ATAN2(AD11,AG11),2*PI())","v":1.570809821943858},{"$f":"DEGREES(AH11)","v":{"v":90.00077321507939,"d":"90.0"}},{"$f":"SQRT(AF11^2*AG11^2+(Z12-Z11)^2)","v":2.155502021532315},{"$f":"DEGREES(AJ11)*60","v":{"v":7410.070113943125,"d":"7410.1"}},{"$nulls":47},{"v":269.9992267849206,"d":"269.99923"},{"v":7410.070113943125,"d":"7410.0701"}]
["PB 3","RAS TANNURAH RACON (K)",{"v":27,"d":"27°"},{"v":11.4,"d":"11.40`"},"N",{"v":50,"d":"050°"},{"v":57.5,"d":"57.50`"},"E",{"v":98.89184782811951,"d":"099°"},{"v":60.81394329207227,"d":"60.8"},{"$f":"+K11-J11","v":{"v":4931.558141652599,"d":"4931.6"}},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},{"$f":"IF(E12=\"N\",RADIANS(C12+(D12/60)),-RADIANS(C12+(D12/60)))","v":0.4745550236172582},{"$f":"IF(H12=\"E\",+RADIANS(F12+(G12/60)),-RADIANS(F12+(G12/60)))","v":0.8893906979954438},0.019634954084936207,6.26355035309465,-3.0718896058628425E-3,0.8894961383826187,0.89011960463655,0.019634954084936207,1.7259883479818887,{"v":98.89184782811951,"d":"98.9"},0.017690059026129676,{"v":60.81394329207227,"d":"60.8"},{"$nulls":47},{"v":98.89184782811951,"d":"98.89185"},{"v":60.81394329207227,"d":"60.8139"}]
["PB 4","FIELD",{"v":27,"d":"27°"},{"v":2,"d":"02.00`"},"N",{"v":52,"d":"052°"},{"v":5,"d":"05.00`"},"E",{"v":131.88581763263926,"d":"132°"},{"v":29.955891612915163,"d":"30.0"},{"v":4870.744198360527,"d":"4870.7"},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},0.47182067445580045,0.90902565208038,0.007272205216643068,6.275913101962943,-0.006521728036198491,0.8907422524501034,0.8920586907370712,0.007272205216643068,2.3018417543743483,{"v":131.88581763263926,"d":"131.9"},0.008713815650265406,{"v":29.955891612915163,"d":"30.0"},{"$nulls":47},{"v":131.88581763263926,"d":"131.88582"},{"v":29.955891612915163,"d":"29.9559"}]
["PB 5","CABLE BANK",{"v":26,"d":"26°"},{"v":42,"d":"42.00`"},"N",{"v":52,"d":"052°"},{"v":30,"d":"30.00`"},"E",{"v":106.49874610577218,"d":"106°"},{"v":104.5795411838232,"d":"104.6"},{"v":4840.788306747611,"d":"4840.8"},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},0.46600291028248597,0.9162978572970231,0.03257947937056083,6.250605827809025,-0.009649705905783667,0.8933713883278376,0.8952998030949143,0.03257947937056083,1.858753768791214,{"v":106.49874610577218,"d":"106.5"},0.030420955398045384,{"v":104.5795411838232,"d":"104.6"},{"$nulls":47},{"v":106.49874610577218,"d":"106.49875"},{"v":104.5795411838232,"d":"104.5795"}]
["PB 6","FORUR ISLAND",{"v":26,"d":"26°"},{"v":12.3,"d":"12.30`"},"N",{"v":54,"d":"054°"},{"v":22,"d":"22.00`"},"E",{"v":96.64091344577552,"d":"097°"},{"v":50.15285243581551,"d":"50.2"},{"v":4736.208765563788,"d":"4736.2"},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},0.457363530485114,0.9488773366675839,0.016144295580947432,6.267041011598639,-1.8796422586359032E-3,0.8972198376038806,0.897591870213388,0.016144295580947432,1.6867021317636413,{"v":96.64091344577552,"d":"96.6"},0.014588873404530646,{"v":50.15285243581551,"d":"50.2"},{"$nulls":47},{"v":96.64091344577552,"d":"96.64091"},{"v":50.15285243581551,"d":"50.1529"}]
["PB 7","TONBE ISLAND",{"v":26,"d":"26°"},{"v":6.5,"d":"06.50`"},"N",{"v":55,"d":"055°"},{"v":17.5,"d":"17.50`"},"E",{"v":70.38069863120359,"d":"070°"},{"v":11.912955468934165,"d":"11.9"},{"v":4686.055913127972,"d":"4686.1"},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},0.4556763788748529,0.9650216322485313,3.6361026083215897E-3,6.279549204571264,1.2961382792950143E-3,0.8979635797038885,0.8977073304985035,3.6361026083215897E-3,1.228374920968369,{"v":70.38069863120359,"d":"70.4"},0.003465338276272771,{"v":11.912955468934165,"d":"11.9"},{"$nulls":47},{"v":70.38069863120359,"d":"70.38070"},{"v":11.912955468934165,"d":"11.9130"}]
["PB 8","TSS OUT",{"v":26,"d":"26°"},{"v":10.5,"d":"10.50`"},"N",{"v":55,"d":"055°"},{"v":30,"d":"30.00`"},"E",{"v":66.65374013681041,"d":"067°"},{"v":51.73019652138883,"d":"51.7"},{"v":4674.142957659038,"d":"4674.1"},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},0.45683993170951576,0.9686577348568529,0.015417075059283247,6.267768232120303,0.006654402881355833,0.8974509275255026,0.8961297330456026,0.015417075059283247,1.1633272241560373,{"v":66.65374013681041,"d":"66.7"},0.015047704200032538,{"v":51.73019652138883,"d":"51.7"},{"$nulls":47},{"v":66.65374013681041,"d":"66.65374"},{"v":51.73019652138883,"d":"51.7302"}]
["PB 9","TSS HORMUZ 1",{"v":26,"d":"26°"},{"v":31,"d":"31.00`"},"N",{"v":56,"d":"056°"},{"v":23,"d":"23.00`"},"E",{"v":65.17850251325903,"d":"065°"},{"v":5.717108158419505,"d":"5.7"},{"v":4622.412761137649,"d":"4622.4"},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},0.46280313998716305,0.9840748099161362,1.6871516102611173E-3,6.2814981555693254,7.8034179774028913E-4,0.8948045300584291,0.8946486050335065,1.6871516102611173E-3,1.1375794703757691,{"v":65.17850251325903,"d":"65.2"},1.6630393509508323E-3,{"v":5.717108158419505,"d":"5.7"},{"$nulls":47},{"v":65.17850251325903,"d":"65.17850"},{"v":5.717108158419505,"d":"5.7171"}]
["PB 10","TSS HORMUZ 2",{"v":26,"d":"26°"},{"v":33.4,"d":"33.40`"},"N",{"v":56,"d":"056°"},{"v":28.8,"d":"28.80`"},"E",{"v":90,"d":"090°"},{"v":3.5779705018346784,"d":"3.6"},{"v":4616.69565297923,"d":"4616.7"},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},0.46350127168796074,0.9857619615263973,1.163552834662962E-3,6.282021754344923,0,0.8944926254586114,0.8944926254586114,1.163552834662962E-3,1.5707963267948966,{"v":90,"d":"90.0"},1.0407894299374826E-3,{"v":3.5779705018346784,"d":"3.6"},{"$nulls":47},{"v":90,"d":"90.00000"},{"v":3.5779705018346784,"d":"3.5780"}]
["PB 11","TSS HORMUZ 3",{"v":26,"d":"26°"},{"v":33.4,"d":"33.40`"},"N",{"v":56,"d":"056°"},{"v":32.8,"d":"32.80`"},"E",{"v":149.3791183222242,"d":"149°"},{"v":62.05287305205036,"d":"62.1"},{"v":4613.117682477395,"d":"4613.1"},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},0.46350127168796074,0.9869255143610602,0.010239264945033355,6.272946042234553,-0.01729925893452955,0.8944926254586114,0.8979246106169625,0.010239264945033355,2.607157448449,{"v":149.3791183222242,"d":"149.4"},0.01805044908467236,{"v":62.05287305205036,"d":"62.1"},{"$nulls":47},{"v":149.3791183222242,"d":"149.37912"},{"v":62.05287305205036,"d":"62.0529"}]
["PB 12","RAS AL KUH 1",{"v":25,"d":"25°"},{"v":40,"d":"40.00`"},"N",{"v":57,"d":"057°"},{"v":8,"d":"08.00`"},"E",{"v":140.00938056519738,"d":"140°"},{"v":13.052279960938492,"d":"13.1"},{"v":4551.064809425345,"d":"4551.1"},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},0.4479678413452113,0.9971647793060936,2.7052603405912645E-3,6.280480046838995,-0.00322507590361609,0.9013291614454622,0.9019577131179077,2.7052603405912645E-3,2.4436246745404535,{"v":140.00938056519738,"d":"140.0"},3.7967543368408923E-3,{"v":13.052279960938492,"d":"13.1"},{"$nulls":47},{"v":140.00938056519738,"d":"140.00938"},{"v":13.052279960938492,"d":"13.0523"}]
["PB 13","RAS AL KUH 2",{"v":25,"d":"25°"},{"v":30,"d":"30.00`"},"N",{"v":57,"d":"057°"},{"v":17.3,"d":"17.30`"},"E",{"v":136.30273186512736,"d":"136°"},{"v":124.48131292684803,"d":"124.5"},{"v":4538.012529464406,"d":"4538.0"},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},0.44505895925855404,0.9998700396466849,0.02754711336064375,6.2556381938189425,-0.02882915937034003,0.9025852843498606,0.9081062143924088,0.02754711336064375,2.378931450509464,{"v":136.30273186512736,"d":"136.3"},0.03621014612964796,{"v":124.48131292684803,"d":"124.5"},{"$nulls":47},{"v":136.30273186512736,"d":"136.30273"},{"v":124.48131292684803,"d":"124.4813"}]
["PB 14","24° NORTH",{"v":24,"d":"24°"},{"v":0,"d":"00.00`"},"N",{"v":58,"d":"058°"},{"v":52,"d":"52.00`"},"E",{"v":136.39000837687638,"d":"136°"},{"v":110.48936444860492,"d":"110.5"},{"v":4413.531216537558,"d":"4413.5"},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},0.4188790204786391,1.0274171530073286,0.024143721319255018,6.259041585860331,-0.025344553488278247,0.9135454576426009,0.9181876770494501,0.024143721319255018,2.38045471299914,{"v":136.39000837687638,"d":"136.4"},0.03214005330106875,{"v":110.48936444860492,"d":"110.5"},{"$nulls":47},{"v":136.39000837687638,"d":"136.39001"},{"v":110.48936444860492,"d":"110.4894"}]
["PB 15","RAS AL HADD",{"v":22,"d":"22°"},{"v":40,"d":"40.00`"},"N",{"v":60,"d":"060°"},{"v":15,"d":"15.00`"},"E",{"v":180,"d":"180°"},{"v":40.00000000000012,"d":"40.0"},{"v":4303.041852088953,"d":"4303.0"},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},0.3956079637853814,1.0515608743265836,0,0,-0.012579196741493666,0.9227624443554423,0.9249818240180641,0,3.141592653589793,{"v":180,"d":"180.0"},0.011635528346628898,{"v":40.00000000000012,"d":"40.0"},{"$nulls":47},{"v":180,"d":"180.00000"},{"v":40.00000000000012,"d":"40.0000"}]
["PB 16","RAS QUMAYLAH",{"v":22,"d":"22°"},{"v":0,"d":"00.00`"},"N",{"v":60,"d":"060°"},{"v":15,"d":"15.00`"},"E",{"v":204.09544375790784,"d":"204°"},{"v":618.9293944162871,"d":"618.9"},{"v":4263.041852088953,"d":"4263.0"},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},0.3839724354387525,1.0515608743265836,6.20609993188317,0.07708537529641624,-0.17236328619713176,0.9271838545667874,0.9535199839956845,0.07708537529641624,2.721047825285186,{"v":155.90455624209216,"d":"155.9"},0.1800392628323136,{"v":618.9293944162871,"d":"618.9"},{"$nulls":47},{"v":204.09544375790784,"d":"204.09544"},{"v":618.9293944162871,"d":"618.9294"}]
["PB 17","SUQUTRA",{"v":12,"d":"12°"},{"v":35,"d":"35.00`"},"N",{"v":55,"d":"055°"},{"v":50,"d":"50.00`"},"E",{"v":208.69878397038536,"d":"209°"},{"v":1647.368785180876,"d":"1647.4"},{"v":3644.112457672666,"d":"3644.1"},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},0.2196205975426198,0.9744754990301674,6.051347404873006,0.2318379023065802,-0.4234819293166806,0.9759801759455132,0.9925652841910086,0.2318379023065802,2.6407043819879976,{"v":151.30121602961464,"d":"151.3"},0.4792001549330909,{"v":1647.368785180876,"d":"1647.4"},{"$nulls":47},{"v":208.69878397038536,"d":"208.69878"},{"v":1647.368785180876,"d":"1647.3688"}]
["PB 18","COMORES",{"v":11,"d":"11°"},{"v":30,"d":"30.00`"},"S",{"v":42,"d":"042°"},{"v":33,"d":"33.00`"},"E",{"v":198.49390683680642,"d":"198°"},{"v":284.70279427502004,"d":"284.7"},{"v":1996.74367249179,"d":"1996.7"},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},-0.2007128639793479,0.7426375967235872,6.256132703773674,0.02705260340591209,-0.0808802924367075,0.9799247046208296,0.9710624674262374,0.02705260340591209,2.8188130877304314,{"v":161.50609316319358,"d":"161.5"},0.08281668582878603,{"v":284.70279427502004,"d":"284.7"},{"$nulls":47},{"v":198.49390683680642,"d":"198.49391"},{"v":284.70279427502004,"d":"284.7028"}]
["PB 19","MOZAMBIQUE",{"v":16,"d":"16°"},{"v":0,"d":"00.00`"},"S",{"v":41,"d":"041°"},{"v":0,"d":"00.00`"},"E",{"v":208.07751478741096,"d":"208°"},{"v":606.3617142253464,"d":"606.4"},{"v":1712.04087821677,"d":"1712.0"},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},-0.2792526803190927,0.7155849933176751,6.194464403536541,0.08872090364304508,-0.16631654377543895,0.9612616959383189,0.935716845140112,0.08872090364304508,2.651547574772076,{"v":151.92248521258904,"d":"151.9"},0.17638347285448722,{"v":606.3617142253464,"d":"606.4"},{"$nulls":47},{"v":208.07751478741096,"d":"208.07751"},{"v":606.3617142253464,"d":"606.3617"}]
["PB 20","PUNTA ZAVORA",{"v":24,"d":"24°"},{"v":55,"d":"55.00`"},"S",{"v":35,"d":"035°"},{"v":55,"d":"55.00`"},"E",{"v":216.38757082097197,"d":"216°"},{"v":285.70629699954657,"d":"285.7"},{"v":1105.6791639914236,"d":"1105.7"},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},-0.4348778719552538,0.62686408967463,6.227916547533099,0.05526875964648714,-0.07499877879860467,0.9069215015644624,0.8920716985642526,0.05526875964648714,2.506509735961216,{"v":143.61242917902803,"d":"143.6"},0.08310859293871473,{"v":285.70629699954657,"d":"285.7"},{"$nulls":47},{"v":216.38757082097197,"d":"216.38757"},{"v":285.70629699954657,"d":"285.7063"}]
["PB 21","CAPE SANTA LUCIA",{"v":28,"d":"28°"},{"v":45,"d":"45.00`"},"S",{"v":32,"d":"032°"},{"v":45,"d":"45.00`"},"E",{"v":216.26875208786186,"d":"216°"},{"v":159.25560973058813,"d":"159.3"},{"v":819.972866991877,"d":"820.0"},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},-0.5017821599483697,0.5715953300281429,6.251594847718489,0.03159045946109729,-0.043054393507114576,0.8767267557075077,0.8675083528120471,0.03159045946109729,2.5085835140670363,{"v":143.73124791213814,"d":"143.7"},0.04632557903449804,{"v":159.25560973058813,"d":"159.3"},{"$nulls":47},{"v":216.26875208786186,"d":"216.26875"},{"v":159.25560973058813,"d":"159.2556"}]
["PB 22","SOUTH OF DURBAN",{"v":30,"d":"30°"},{"v":53.4,"d":"53.40`"},"S",{"v":30,"d":"030°"},{"v":56.4,"d":"56.40`"},"E",{"v":220.19148377714805,"d":"220°"},{"v":208.9300695183834,"d":"208.9"},{"v":660.7172572612889,"d":"660.7"},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},-0.5391322059410484,0.5400048705670456,6.23681772671827,0.04636758046131606,-0.054885167381075385,0.858154522511046,0.8458707574071632,0.04636758046131606,2.4401189304166726,{"v":139.80851622285195,"d":"139.8"},0.060775293658607225,{"v":208.9300695183834,"d":"208.9"},{"$nulls":47},{"v":220.19148377714805,"d":"220.19148"},{"v":208.9300695183834,"d":"208.9301"}]
["PB 23","EAST LONDON",{"v":33,"d":"33°"},{"v":33,"d":"33.00`"},"S",{"v":28,"d":"028°"},{"v":17,"d":"17.00`"},"E",{"v":241.18812586085238,"d":"241°"},{"v":87.14863268556118,"d":"87.1"},{"v":451.7871877429055,"d":"451.8"},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},-0.5855579640440975,0.49363729010572954,6.256423591982339,0.026761715197246405,-0.014719600647821247,0.8334038487252763,0.8300024610904573,0.026761715197246405,2.0736583941932296,{"v":118.81187413914763,"d":"118.8"},0.02535050964956985,{"v":87.14863268556118,"d":"87.1"},{"$nulls":47},{"v":241.18812586085238,"d":"241.18813"},{"v":87.14863268556118,"d":"87.1486"}]
["PB 24","WEST OF CAPE RECIFE",{"v":34,"d":"34°"},{"v":15,"d":"15.00`"},"S",{"v":26,"d":"026°"},{"v":45,"d":"45.00`"},"E",{"v":256.8308460526402,"d":"257°"},{"v":96.56462732512952,"d":"96.6"},{"v":364.6385550573443,"d":"364.6"},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},-0.5977752688080579,0.46687557490848314,6.250024051391694,0.033161255787892197,-0.007759069702215483,0.8265897491271886,0.8247819437449513,0.033161255787892197,1.8006414228783334,{"v":103.16915394735982,"d":"103.2"},0.028089511463079916,{"v":96.56462732512952,"d":"96.6"},{"$nulls":47},{"v":256.8308460526402,"d":"256.83085"},{"v":96.56462732512952,"d":"96.5646"}]
["PB 25","CAPE ST. FRANCIS",{"v":34,"d":"34°"},{"v":37,"d":"37.00`"},"S",{"v":24,"d":"024°"},{"v":51,"d":"51.00`"},"E",{"v":266.3136152805932,"d":"266°"},{"v":124.42614221317564,"d":"124.4"},{"v":268.07392773221477,"d":"268.1"},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},-0.6041748093987037,0.43371431912059094,6.239261187671062,0.04392411950852404,-2.8299641509531314E-3,0.8229711546617382,0.8223092396919742,0.04392411950852404,1.6351358776437526,{"v":93.6863847194068,"d":"93.7"},0.03619409761957699,{"v":124.42614221317564,"d":"124.4"},{"$nulls":47},{"v":266.3136152805932,"d":"266.31362"},{"v":124.42614221317564,"d":"124.4261"}]
["PB 26","TSS IN",{"v":34,"d":"34°"},{"v":45,"d":"45.00`"},"S",{"v":22,"d":"022°"},{"v":20,"d":"20.00`"},"E",{"v":261.6093311359798,"d":"262°"},{"v":78.80927292794783,"d":"78.8"},{"v":143.64778551903913,"d":"143.6"},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},-0.6065019150680295,0.3897901996120669,6.255550927356342,0.027634379823243516,-0.004076091648164332,0.8216469379421637,0.82069165475275,0.027634379823243516,1.717241124916621,{"v":98.39066886402018,"d":"98.4"},0.022924688228258692,{"v":78.80927292794783,"d":"78.8"},{"$nulls":47},{"v":261.6093311359798,"d":"261.60933"},{"v":78.80927292794783,"d":"78.8093"}]
["PB 27","TSS OUT",{"v":34,"d":"34°"},{"v":56.5,"d":"56.50`"},"S",{"v":20,"d":"020°"},{"v":45,"d":"45.00`"},"E",{"v":245.38441649982087,"d":"245°"},{"v":36.01197839268674,"d":"36.0"},{"v":64.8385125910913,"d":"64.8"},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},-0.6098471294676854,0.3621558197888234,6.2715497788329575,0.011635528346628898,-0.005330989305595397,0.8197355828213687,0.8184828143260461,0.011635528346628898,2.0004193061726125,{"v":114.61558350017913,"d":"114.6"},0.010475459885157318,{"v":36.01197839268674,"d":"36.0"},{"$nulls":47},{"v":245.38441649982087,"d":"245.38442"},{"v":36.01197839268674,"d":"36.0120"}]
["PB 28","CAPE AGULHAS",{"v":35,"d":"35°"},{"v":11.5,"d":"11.50`"},"S",{"v":20,"d":"020°"},{"v":5,"d":"05.00`"},"E",{"v":276.9738260454326,"d":"277°"},{"v":28.826534198407362,"d":"28.8"},{"v":28.82653419840456,"d":"28.8"},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},-0.6142104525976712,0.3505202914421945,6.273004219876286,0.010181087303300251,1.2453595392335512E-3,0.8172287283738303,0.8175219270064169,0.010181087303300251,1.4490801008407628,{"v":83.02617395456744,"d":"83.0"},0.00838529889501588,{"v":28.826534198407362,"d":"28.8"},{"$nulls":47},{"v":276.9738260454326,"d":"276.97383"},{"v":28.826534198407362,"d":"28.8265"}]
["PB 29","QUOIN POINT",{"v":35,"d":"35°"},{"v":8,"d":"08.00`"},"S",{"v":19,"d":"019°"},{"v":30,"d":"30.00`"},"E","",{"v":0,"d":"0.0"},{"v":-2.8030910925735952E-12,"d":"-0.0"},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},-0.6131923438673411,0.34033920413889424,5.942846103040692,0.34033920413889424,0.6556797708118176,0.8178150544913865,0.9352009489451361,0.34033920413889424,0.47878156061731747,{"v":27.43216273205928,"d":"27.4"},0.6908766458630974,{"v":2375.0589583265933,"d":"2375.1"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
["PB 30",{"$nulls":7},{"$f":"IF(C39=\"\",\"\",IF(AC39<AB39,360-AI39,AI39))","v":""},{"$f":"IF(C39=\"\",0,+AK39)","v":{"v":0,"d":"0.0"}},{"$f":"+K38-J38","v":{"v":-2.8030910925735952E-12,"d":"-0.0"}},null,"< 1 h","Vis","Rdr","Gps","MAN",{"$nulls":8},0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"v":0,"d":"0.0"},{"$nulls":47},"",{"v":0,"d":"0.0000"}]
[" ",null," "," "," ","TOTAL DISTANCE:",{"$nulls":3},{"$f":"SUM(J10:J39)","v":{"v":16016.103436472162,"d":"16016.1"}},null," "]

{"sheet":"Amendment to Passage Plan","index":15,"n_rows":20,"n_cols":4,"rows_kept":20,"merged":[[1,0,1,4],[2,1,2,2],[3,1,3,2],[4,1,4,2],[6,1,6,2],[10,1,10,2],[12,0,12,4],[13,0,13,4],[14,0,14,4],[15,0,15,4],[16,0,16,4],[17,0,17,4],[18,0,18,4],[19,1,19,4]]}
[]
["Amendment to Passage Plan"]
["Amendment No",null,null,"Voyage:"]
["Amendment Commenced (Date and Time (LT/UTC))",null,null,"Amendment Completed \n(Date and Time (LT/UTC)) "]
["Amendment of Passage \nStarted at Position  ",null,null,"Amendment of Passage \nCompleted at Position "]
["Reasons for Amendment of Passage"]
["Additional ENC’s  ",null,null,"Additional Publications "]
[null,"UKC for new route calculated ",null,"New UKC:"]
[null,"Changes to ECDIS route  ",null,"Note:"]
[null,"Risk Assessment"]
[null,"Applicable NAVAREA & NAVTEX \nmessages have been processed   ",null,"Note:"]
[null,"Briefing with Bridge and Engine Team  ",null,"Note:"]
[]
["Remarks:"]
[]
[]
[]
[]
[]
["SIGNATURES FOR AMENDMENT OF PASSAGE"]

{"sheet":"Post Voyage Review","index":16,"n_rows":47,"n_cols":8,"rows_kept":47,"merged":[[0,0,2,1],[0,2,0,6],[0,7,0,8],[1,2,1,6],[1,7,1,8],[2,2,2,6],[2,7,2,8],[4,0,4,8],[10,0,10,5],[23,0,24,8],[25,0,42,8]]}
["NAV-01",{"$nulls":6},"Doc No :  NAV-01"]
[null,null,"POST VOYAGE REVIEW",{"$nulls":4},"Revision: 01                                                              \nDate: 15 Oct 2024"]
[{"$nulls":7},"Issued by: DPA\nApproved by: MD"]
["Post Voyage review to be carried out by the Master with Bridge Team"]
["(Post-voyage review to be carried out after every voyage to check if any new hazards or useful information discovered, for incorporation in the future passage plan) "]
["Points to consider:"]
["1. Any amendment to the waypoints"]
["2. Appropriateness of charts and publications."]
["3. Adequateness of the Bridge team composition"]
["4. UKC - calculated vs actual observed"]
["5. Adequateness of position verification interval"]
["6. Initiate ECDIS Backup as per manufacturers instructions"]
{"$rows_empty":32}
["Master's name :"]
[]
["Signature :"]

{"sheet":"Emer and Contingency Plan","index":17,"n_rows":32,"n_cols":8,"rows_kept":32,"merged":[[0,0,0,12],[2,0,2,12],[3,0,3,12],[5,1,5,3],[5,4,5,6],[5,7,5,12],[6,0,8,0],[6,1,8,3],[6,4,8,6],[6,7,6,12],[7,7,7,12],[8,7,8,12],[9,0,10,0],[9,1,10,3],[9,4,10,6],[9,7,9,12],[10,7,10,12],[11,0,16,0],[11,1,16,3],[11,4,11,6],[11,7,11,12],[12,4,12,6],[12,7,12,12],[13,4,13,6],[13,7,13,12],[14,4,16,6],[14,7,14,12],[15,7,15,12],[16,7,16,12],[17,0,18,0],[17,1,18,3],[17,4,18,6],[17,7,17,12],[18,7,18,12],[19,0,20,0],[19,1,20,3],[19,4,20,6],[19,7,19,12],[20,7,20,12],[21,0,22,0],[21,1,22,3],[21,4,22,6],[21,7,21,12],[22,7,22,12],[23,0,24,0],[23,1,24,3],[23,4,24,6],[23,7,23,12],[24,7,24,12],[25,0,26,0],[25,1,26,3],[25,4,26,6],[25,7,25,12],[26,7,26,12],[31,0,31,12]]}
[]
[]
["Emergency and Contingency Plan"]
["Vessel should prepare a separate HSSEQ-18 (Risk Assessment) if required."]
[]
["No","Hazard",null,null,"Risk",null,null,"Contingency Plan / Control Measures"]
[1,"Loss of Propulsion or Steering Failure",null,null,"Collision or Grounding"]
[]
[]
[2,"Failure of any critical Navigational Equipment",null,null,"Collision or Grounding"]
[]
[3,"Adverse weather and sea conditions ",null,null,"Inability to keep a proper lookout due to loss of visibility"]
[{"$nulls":4},"Reduction of UKC due to rolling and pitching"]
[{"$nulls":4},"Pilot cannot disembark from the ship at designated disembarkation point."]
[{"$nulls":4},"Grounding"]
[]
[]
[4,"Unscheduled movement of any other vessel in the pilotage water",null,null,"Collision"]
[]
[5,"Inadequate navigation charts & publications (Small scale, not corrected)",null,null,"Unaware of nav warnings / changes, Grounding"]
[]
[6,"Delay in arrival of pilot",null,null,"Collision or Grounding"]
[]
[7,"Unreliable Navigational aids",null,null,"Incorrect position fixing causing grounding"]
[]
[]
[]
[]
[]
["Notes: "]
["1. Additional lines can be added to above to make this plan ship and voyage specific."]
["2. Contingency plan in case of Loss of Propulsion or Steering Failure for each leg of the passage in pilotage waters and approached to the port must included. "]

{"sheet":"Sample Emer & Contingency Plan","index":18,"n_rows":33,"n_cols":8,"rows_kept":33,"merged":[[9,0,9,12],[10,0,10,12],[11,0,11,12],[13,1,13,3],[13,4,13,6],[13,7,13,12],[14,0,16,0],[14,1,16,3],[14,4,16,6],[14,7,14,12],[15,7,15,12],[16,7,16,12],[17,0,18,0],[17,1,18,3],[17,4,18,6],[17,7,17,12],[18,7,18,12],[19,0,24,0],[19,1,24,3],[19,4,19,6],[19,7,19,12],[20,4,20,6],[20,7,20,12],[21,4,21,6],[21,7,21,12],[22,4,24,6],[22,7,22,12],[23,7,23,12],[24,7,24,12],[25,0,26,0],[25,1,26,3],[25,4,26,6],[25,7,25,12],[26,7,26,12],[27,0,28,0],[27,1,28,3],[27,4,28,6],[27,7,27,12],[28,7,28,12],[29,0,30,0],[29,1,30,3],[29,4,30,6],[29,7,30,12],[31,0,32,0],[31,1,32,3],[31,4,32,6],[31,7,31,12],[32,7,32,12],[33,0,34,0],[33,1,34,3],[33,4,34,6],[33,7,33,12],[34,7,34,12]]}
{"$rows_empty":9}
["Emergency and Contingency Plan "]
["Below if for guidance only, vessel should prepare passage specific plan.                                                                                  "]
["Vessel should prepare a separate HSSEQ-18 (Risk Assessment) if required."]
[" "]
["No","Emergency Situation",null,null,"Likely consequence ",null,null,"Contingency Plan / Control Measures"]
[1,"Loss of Propulsion or Steering Failure",null,null,"Collision or Grounding",null,null,"WPT 1 to 4: There is no emergency anchorage in this area. In case of emergency, drop anchor in the channel and call for tug assistance."]
[{"$nulls":7},"WPT 5 to 7: Anchor at contingency anchorage in position 03 35N 041 22E"]
[{"$nulls":7},"WPT 7 to 12: There is sufficient sea room available to remain adrift in this area. Keep the anchors ready for letting go."]
[2,"Failure of any critical Navigational Equipment",null,null,"Collision or Grounding",null,null,"Assess the risk associated with proceeding with passage in this condition."]
[{"$nulls":7},"Consider aborting passage, and anchor or drift at a safe location "]
[3,"Adverse weather and sea conditions ",null,null,"Inability to keep a proper lookout due to loss of visibility",null,null,"Reduce speed and / or abort passage "]
[{"$nulls":4},"Reduction of UKC due to rolling and pitching",null,null,"Verify the UKC of the ship. Consider aborting passage in case if it is not considered safe to proceed with the voyage."]
[{"$nulls":4},"Pilot cannot disembark from the ship at designated disembarkation point.",null,null,"Discuss the available options with the Pilot and VTIS. Allow the pilot to disembark earlier only after assessing that it is safe to continue the voyage without the pilot. Consider aborting passage and anchor in the channel or at th enearest contingency anchorage in case if it is not considered safe to proceed out without pilot."]
[{"$nulls":4},"Grounding",null,null,"Plan Passage route after giving consideration to direction and strength of current."]
[{"$nulls":7},"Closely monitor actual course made good during the passage."]
[{"$nulls":7},"Verify ship's position and drift using Parallel Index."]
[4,"Unscheduled movement of any other vessel in the pilotage water",null,null,"Collision",null,null,"Discuss the intentions of other ship with pilot or VTIS. In case if pilot gives any advice for manouvering after communicationg with the other vessel in any foreign language, then request the pilot to explain in English the intentions of other ship. "]
[{"$nulls":7},"Plot the other vessel on ARPA and closely monitor her actions"]
[5,"Inadequate navigation charts & publications (Small scale, not corrected)",null,null,"Unaware of nav warnings / changes, Grounding",null,null,"Digitrace correction for quick updates Obtain charts through agent or via e mail from Office"]
[{"$nulls":7},"Office contacted for assistance"]
[6,"Delay in arrival of pilot",null,null,"Collision or Grounding",null,null,"Do not proceed any further than abort point unless it has been positively confirmed that vessel can safely enter the pilotage water without pilot. Abort the passage in case of any doubt, and drop anchor at anchorage location XXXX N XXXX E in case if the passage is aborted."]
[]
[7,"Unreliable Navigational aids",null,null,"Incorrect position fixing causing grounding",null,null,"Consider aborting passage, and anchor or drift at a safe location "]
[{"$nulls":7},"Discuss the available options with the Pilot and VTIS. Allow the pilot to embark earlier if safe to do so. "]